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://gis.legis.iowa.gov/arcgis/rest/directories/arcgisoutput/System/PublishingTools_GPServer/System_PublishingTools/ExcelAnalyze.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: excelFile

Data Type: GPString
Display Name Input Excel File
Description:
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: validateWorkspace

Data Type: GPString
Display Name Validation Workspace
Description:
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: excelInfo

Data Type: GPString
Display Name Excel Info
Description:
Direction: esriGPParameterDirectionOutput
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeDerived
Category:

Supported Operations:   Submit Job

Child Resources:   Metadata