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.

Environment

The Convert Data Table To XLSX activity is a server activity. It can only be used in server workflows, which require on-premises Workflow.

Offline Support

This activity does not work when the device is offline.

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 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.

Properties

For information about the ID, Display Name, and Description properties, see Properties Common to all Activities.

© 2019 Latitude Geographics Group Ltd. All Rights Reserved.

Documentation Version 5.11