XLSX To DataSet Activity

Description:

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

Inheritance Hierarchy:

System.Object
  System.Activities.Activity
    System.Activities.CodeActivity
      Geocortex.Workflow.Activities.XlsxToDataSet

Function:

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.

Properties:

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.
Source	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.
Misc
Display Name	DataSetToXlsx 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
Result	The DataSet containing the data.

Version Information:

Supported from: Geocortex Essentials 4.4.