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.
