Convert XLSX To Data Set Activity

Description

This activity converts a Microsoft Excel (.xlsx) workbook to a data set. Each worksheet in the workbook becomes a data table in the data set.

Usage

The Read File Bytes activity could be used to read an .xlsx file on the server. The file bytes could then be passed to the Convert XLSX To Data Set activity to produce a DataSet object. The workflow could then access the tables, rows and columns of the data set to read the data values.

Inputs

Xlsx

Required Type: Number[] The byte content of the Microsoft Excel (.xlsx) workbook file.

Password

Optional Type: String The password to the Microsoft Excel (.xlsx) workbook. This is only required if the workbook is protected.

Outputs

result

Type: Object A data set representing the worksheets in the Microsoft Excel workbook. Each worksheet in the workbook is a table in the data set.

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.