Display Name: ExcelToTableServer
Description: 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" : [ , ,...]}
where each sheet is an object like the following:
{ "name" : , "id": , "fields": [ {"name": , "type": , "length": }, ]}
Category:
Help URL: https://maps.udot.utah.gov/arcgis/rest/directories/arcgisoutput/System/PublishingToolsEx_GPServer/System_PublishingToolsEx/ExcelToTableServer.htm
Execution Type: esriExecutionTypeAsynchronous
Parameters:
Parameter: excelFile
Data Type: GPString
Display Name excelFile
Description:
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: validateWorkspace
Data Type: GPString
Display Name validateWorkspace
Description:
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: sheetName
Data Type: GPString
Display Name sheetName
Description:
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:
Parameter: evalCount
Data Type: GPLong
Display Name evalCount
Description:
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:
Supported Operations:
Submit Job