Convert Data Table To XLSX Activity


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.


Data Table


Type: DataTable | DataTable[]

The data table or data tables to convert.



Type: String

The password for the Microsoft Excel (.xlsx) workbook.



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.


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.