Geocortex Workflow Help
Open topic with navigation
This activity converts a Microsoft Excel (.xlsx) workbook to a data set. Each worksheet in the workbook becomes a data table in the data set.
The Read File Bytes activity could be used to read an .xlsx file on the server. The file bytes could then be passed to the Convert XLSX To Data Set activity to produce a DataSet object. The workflow could then access the tables, rows and columns of the data set to read the data values.
The Convert XLSX To Data Set activity is a server activity. It can only be used in server workflows, which require on-premises Workflow.
This activity does not work when the device is offline.
Type: Number Array
The byte content of the Microsoft Excel (.xlsx) workbook file.
The password to the Microsoft Excel (.xlsx) workbook. This is only required if the workbook is protected.
A data set representing the worksheets in the Microsoft Excel workbook. Each worksheet in the workbook is a table in the data set.
For information about the ID, Display Name, and Description properties, see Properties Common to all Activities.