Description
This activity converts one or more data tables to a Microsoft Excel (.xlsx) workbook. Each table becomes a worksheet in the workbook.
Usage
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.
Inputs
Data Table |
Required The data table or data tables to convert. |
Password |
Optional Type: String The password for the Microsoft Excel (.xlsx) workbook. |
Outputs
result |
Type: Number[] 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. |
Properties
For information about the ID, Display Name, and Description properties, see Properties Common to all Activities.
Connectivity Requirements
This activity does not work when the device has intermittent connectivity to the network.
