{ "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": "http://agrilanduse.doa.gov.my/mygeosvr/rest/directories/arcgisoutput/System/PublishingToolsEx_GPServer/System_PublishingToolsEx/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": "" } ] }