{ "name": "ExcelAnalyze", "displayName": "ExcelAnalyze", "description": "This function returns information about an excel file.\n\nThe function is used by the Analyze and Publish operations in on-premise Portal.\n\nFor each sheet in the excel file it will return the sheet name, id, and the list of fields.\nThe result is a json with this syntax:\n\n { \"sheets\" : [ , ,...]}\n\nwhere each sheet is an object like the following:\n\n { \"name\" : , \"id\": , \"fields\": [ {\"name\": , \"type\": , \"length\": }, ]}", "category": "", "helpUrl": "http://gis.legis.iowa.gov/arcgis/rest/directories/arcgisoutput/System/PublishingToolsEx_GPServer/System_PublishingToolsEx/ExcelAnalyze.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "excelFile", "dataType": "GPString", "displayName": "excelFile", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "validateWorkspace", "dataType": "GPString", "displayName": "validateWorkspace", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "evalCount", "dataType": "GPLong", "displayName": "evalCount", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": null, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "excelInfo", "dataType": "GPString", "displayName": "excelInfo", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": "", "parameterType": "esriGPParameterTypeDerived", "category": "" } ] }