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.

© 2019 Latitude Geographics Group Ltd. All Rights Reserved.

Documentation Version 4.11