Geocortex Workflow Help
Open topic with navigation
This activity converts one or more data tables to a Microsoft Excel (.xlsx) workbook. Each table becomes a worksheet in the workbook.
The Run SQL Query activity could be used to run a database query and produce a data table. The data table could then be passed to the Convert Data Table To XLSX activity to produce the byte data representing a .xlsx file. Then use the Create Download activity to generate a URL that allows an end user to download the file, or use the Write File Bytes activity to save the file to the server.
The Convert Data Table To XLSX 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.
The data table or data tables to convert.
The password for the Microsoft Excel (.xlsx) workbook.
Type: Number Array
The result byte content of the Microsoft Excel (.xlsx) workbook file.
Bytes are the raw binary values that represent content. A byte array is represented by a list of numbers between 0 and 255. This content is not human readable, and should be used an input to other file activities, such as the Write File Bytes activity.
For information about the ID, Display Name, and Description properties, see Properties Common to all Activities.