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.

Environment

The Convert XLSX To Data Set 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

Xlsx

Required

Type: Number Array

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.

© 2019 Latitude Geographics Group Ltd. All Rights Reserved.

Documentation Version 5.11