XLSX To DataSet Activity


Converts a Microsoft Excel (.xlsx) spreadsheet to a DataSet.

Inheritance Hierarchy:



This activity allows you convert a Microsoft Excel (.xlsx) spreadsheet containing arbitrary data into a DataSet. Each worksheet in the spreadsheet becomes a DataTable in the DataSet.

In a Workflow:

You would use this activity to create a DataSet that can then be passed as an input argument into another activity.


Name Description

In Arguments

Infer Column Types

If true, the data type of each column will be inferred from the raw values of the workbook. If false, the data type of all columns will be System.Object. The default value is false.


The binary XLSX input to convert.

Use First Row As Header

If true, use the first row of each worksheet as column headers. The default is true.


Display Name


You can change the name of an activity to one that describes what it does. A descriptive name can make a workflow easier to interpret and maintain.

Out Arguments


The DataSet containing the data.

Version Information:

Supported from: Geocortex Essentials 4.4.