Display Name: ExportExcel

Description: Create xlsx file from json data

Category:

Help URL: https://gis.charttools.noaa.gov/arcgis/rest/directories/arcgisoutput/nav_updates/ExportExcel_GPServer/nav_updates_ExportExcel/ExportExcel.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: features_as_Json

Data Type: GPString
Display Name Features As JSON
Description: Navigation corrections data in json format
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: [{"Item Name":"Visible Wreck","Charting Label":"PA Chart No. 1: K24","Action Taken":"Add","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°10'03.600\"N","Longitude DMS":"089°04'06.000\"W","Latitude":29.167666,"Longitude":-89.06833267},{"Item Name":"Calcasieu Channel Light 56","Charting Label":"Fl R 2.5s 17ft 4M \"56\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°49'17.524\"N","Longitude DMS":"093°20'48.789\"W","Latitude":29.82153378,"Longitude":-93.3468855},{"Item Name":"Calcasieu Channel Light 60","Charting Label":"Fl R 2.5s 17ft 4M \"60\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°50'19.496\"N","Longitude DMS":"093°20'47.042\"W","Latitude":29.83874856,"Longitude":-93.34640022},{"Item Name":"Calcasieu Channel Light 62","Charting Label":"Fl R 4s 17ft 4M \"62\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°51'09.804\"N","Longitude DMS":"093°20'43.040\"W","Latitude":29.85272333,"Longitude":-93.34528856},{"Item Name":"Calcasieu Channel Light 68","Charting Label":"Fl R 4s 17ft 4M \"68\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°54'05.657\"N","Longitude DMS":"093°20'27.738\"W","Latitude":29.90157139,"Longitude":-93.341038},{"Item Name":"Calcasieu Channel Light 75","Charting Label":"Fl G 4s 17ft 4M \"75\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°57'39.665\"N","Longitude DMS":"093°20'16.610\"W","Latitude":29.96101806,"Longitude":-93.33794689},{"Item Name":"Calcasieu Channel Light 77","Charting Label":"Fl G 4s 17ft 4M \"77\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°58'35.223\"N","Longitude DMS":"093°20'11.450\"W","Latitude":29.97645017,"Longitude":-93.33651356},{"Item Name":"Calcasieu Channel Light 79","Charting Label":"Fl G 6s 17ft 4M \"79\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°59'42.615\"N","Longitude DMS":"093°20'05.125\"W","Latitude":29.9951705,"Longitude":-93.33475661},{"Item Name":"Calcasieu Channel Light 117","Charting Label":"Q G 17ft 4M \"117\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"30°12'26.443\"N","Longitude DMS":"093°16'18.658\"W","Latitude":30.20734528,"Longitude":-93.27184878},{"Item Name":"Devils Elbow Light 1","Charting Label":"Oc G 4s 17ft 3M \"1\" Ra Ref","Action Taken":"Change","Date Received":"3/26/2024 8:00PM","Latitude DMS":"30°05'48.822\"N","Longitude DMS":"093°19'14.371\"W","Latitude":30.09689467,"Longitude":-93.32065794},{"Item Name":"Dangerous Wreck","Charting Label":"PA Chart No. 1: K28","Action Taken":"Delete","Date Received":"3/26/2024 8:00PM","Latitude DMS":"29°09'58.900\"N","Longitude DMS":"089°27'35.000\"W","Latitude":29.16636111,"Longitude":-89.45972222},{"Item Name":"Mermentau River Crossing Light 2","Charting Label":"Fl R 2.5s 17ft 3M \"2\" Ra Ref","Action Taken":"Relocate","Date Received":"4/2/2024 8:00PM","Latitude DMS":"29°58'23.620\"N","Longitude DMS":"092°47'14.570\"W","Latitude":29.97322711,"Longitude":-92.78738022},{"Item Name":"Pile","Charting Label":"Pile PA Chart No. 1: F22","Action Taken":"Add","Date Received":"4/2/2024 8:00PM","Latitude DMS":"30°18'35.910\"N","Longitude DMS":"089°14'43.218\"W","Latitude":30.309975,"Longitude":-89.245338},{"Item Name":"Platform: Fieldwood-101-6","Charting Label":"Chart No. 1: L10","Action Taken":"Delete","Date Received":"4/2/2024 8:00PM","Latitude DMS":"28°51'28.303\"N","Longitude DMS":"090°27'34.045\"W","Latitude":28.85786194,"Longitude":-90.45945694},{"Item Name":"Platform: Fieldwood-108-14","Charting Label":"Chart No. 1: L10","Action Taken":"Delete","Date Received":"4/2/2024 8:00PM","Latitude DMS":"28°28'17.994\"N","Longitude DMS":"092°11'43.493\"W","Latitude":28.47166433,"Longitude":-92.19541439}]
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: Output_Excelfile

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

Supported Operations:   Submit Job

Child Resources:   Metadata