ExcelAnalyzeServer

Titleā€ƒ ExcelAnalyzeServer

Summary

This function returns information about an excel file. The function is used by the Analyze and Publish operations in on-premise Portal. For each sheet in the excel file it will return the sheet name, id, and the list of fields. The result is a json with this syntax: { "sheets" : [ <sheet1>, <sheet2>,...]} where each sheet is an object like the following: { "name" : <name>, "id": <id>, "fields": [ {"name": <fname>, "type": <ftype>, "length": <theLength> }, ]}


Usage

Syntax

Parameter Explanation
excelFile

validateWorkspace (Optional)

fieldTypeVersion (Optional)

Code Samples

Tags

Credits

Use limitations