Display Name: ExcelAnalyze

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://atlas.cws.ucdavis.edu/arcgis/rest/directories/arcgisoutput/System/PublishingToolsEx_GPServer/System_PublishingToolsEx/ExcelAnalyze.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: evalCount

Data Type: GPLong
Display Name evalCount
Description:
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: excelInfo

Data Type: GPString
Display Name excelInfo
Description:
Direction: esriGPParameterDirectionOutput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeDerived
Category:

Supported Operations:   Submit Job