Convert Data Table To XLSX Activity
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.
Supported Environments
Environments capable of running this activity
Server
|
Client |
||||
Web |
Mobile |
Experience Builder |
Web AppBuilder |
Geocortex Viewer for HTML5 |
|
---|---|---|---|---|---|
|
|
|
|
|
|
Levels of Support: |
Connectivity Requirements
This activity does not work when the device has intermittent connectivity to the network.