{ "name": "ExcelToTableServer", "displayName": "ExcelToTableServer", "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": "https://hayawater.mm.gov.om/server/rest/directories/arcgisoutput/System/PublishingTools_GPServer/System_PublishingTools/ExcelToTableServer.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": "sheetName", "dataType": "GPString", "displayName": "sheetName", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "evalCount", "dataType": "GPLong", "displayName": "evalCount", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": null, "parameterType": "esriGPParameterTypeOptional", "category": "" } ] }