Skip to main content
Version: Current

Read Range

Description​

The Read Range activity reads data from a worksheet and returns the result as a DataTable.

The activity can read a specific range, a used region starting from a specified cell, or an entire worksheet.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Workbook Configuration​

This activity requires an Excel workbook.

Learn more → Excel Workbook Configuration

Worksheet Selection​

This activity operates on a worksheet within the workbook.

Learn more → Excel Worksheet Selection

Range​

Range of cells to read.

Learn more → Worksheet Data Selection

Examples:

  • A1:D100
  • A:C
  • B2:F50

Behavior depends on the value provided:

  • When a range is specified, only the specified range is read.
  • When a single cell address is specified, reading begins at that cell and continues through the worksheet's used region.
  • When no range is specified, the entire worksheet is read.

Include Column Names​

Determines whether the first row of the selected data is treated as column headers.

When enabled:

  • The first row becomes the DataTable column names.
  • Data is read starting from the next row.

When disabled:

  • Generic column names are generated.
  • All rows are treated as data.

Default value is True.

Preserve Format​

Determines whether cell display formatting is preserved when values are returned.

When enabled, values are returned as they appear in Excel.

Examples:

Cell ValueCell FormatReturned Value
1234.5Currency$1,234.50
0.25Percentage25%
2026-06-18Date18-Jun-2026

When disabled, the underlying cell values are returned without display formatting.

Default value is True.

Exclude Duplicate Columns​

Determines how duplicate column names are handled when Include Column Names is enabled.

When enabled:

  • Duplicate columns are ignored.

When disabled:

  • Duplicate column names are preserved by appending Excel column identifiers to the generated column names.

Default value is True.

Behavior​

The selected worksheet data is converted into a DataTable.

The DataTable structure is determined by the selected range and the column name configuration options.

Formula cells return their calculated values rather than their formula expressions.

Outputs​

Data Table​

Returns a DataTable containing the data read from the worksheet.

The resulting DataTable can be used by subsequent workflow activities for filtering, transformation, iteration, reporting, and data processing.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling