{ "name": "TablesToExcel", "displayName": "TablesToExcel", "description": "This function takes multiple tables and writes them to an output excel file.\nEach table will become a worksheet in the excel file.\nThe function returns the excel file path.\n\nThe first parameter is a json string with this syntax:\n\n {\"tables\" : [ , ,...] }\n\nwhere each table object is:\n\n { \"path\": \", \"targetName\": , \"where\": , \"includeGeometry\" : true/false, \"xColumnName\": , \"yColumnName\" : }\n\nThe path property is required. The others are optional.\nThe targetName will be used as the worksheet name. Otherwise the name of the table will be used.\n", "category": "", "helpUrl": "https://delivery.maps.gov.bc.ca/arcgis/rest/directories/arcgisoutput/System/PublishingTools10x_GPServer/System_PublishingTools10x/TablesToExcel.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "tablesSpec", "dataType": "GPString", "displayName": "tablesSpec", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "targetSrId", "dataType": "GPString", "displayName": "targetSrId", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "excelFile", "dataType": "GPString", "displayName": "excelFile", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" } ] }