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 Type: DataTable | DataTable[] 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.