Read Cell Range

Description

Reads a Google Sheets range into an IbDataTable for use by CSV, database, spreadsheet, and other table-consuming activities.

Configuration

Select the Google Sheets connection and spreadsheet, then set Sheet Name explicitly when the workflow must target a particular tab. See Google Sheets Data Selection.

Property	Description
Cell Range	Required A1 range, such as A1:C10.
Sheet Name	Target tab. Supply it explicitly to avoid dependence on tab order.
Include Header	Use the first returned row as column names and exclude it from data. Default: False.
Exclude Duplicate Columns	Discard later columns with a duplicate header name. Default: False. Applies to header-based names.
Transpose	Read columns as rows before interpreting headers. Default: False.

Without headers, generated names use the source column positions, such as Column1. Blank headers also receive generated names. When duplicate headers are retained, later names receive a column-letter suffix, such as Name_B.

Output

DataTable is the IbDataTable read from the range. Bind the whole value to a compatible table input. If the service returns no values, DataTable can be empty; check that a value is present before passing it to an activity that requires a table.

Example

Suppose A1:B3 contains:

Customer	Amount
Acme	125
Contoso	80

Set Cell Range to A1:B3, enable Include Header, and leave Transpose off. DataTable has the columns Customer and Amount and two data rows. Bind it to Write To CSV → Data Table or Import From DataTable → DataTable.

With Transpose on, the range is interpreted by columns before header extraction. The first source column becomes the header values. Review the resulting names before using this option with header-based data.

For older activity versions, replace the deprecated node with the current Read Cell Range activity when migrating to the DataTable output. Rebind downstream outputs after replacement.

Execution settings

See Execution Control and On Error.