Skip to main content
Version: Current

Write Range

Description​

The Write Range activity writes data from a DataTable to a worksheet within an Excel workbook.

Data is written starting at a specified cell and expands automatically to accommodate all rows and columns contained in the DataTable.

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

Data Table​

DataTable containing the data to write to the worksheet.

Each DataTable row is written as a worksheet row, and each DataTable column is written as a worksheet column.

Starting Cell​

Top-left cell where writing begins.

Examples:

  • A1
  • B5
  • D10

Default value is A1.

Add Headers​

Determines whether DataTable column names are written as the first row.

When enabled:

  • DataTable column names are written to the worksheet.
  • Data rows begin on the next row.

When disabled:

  • Only DataTable row data is written.

Default value is False.

Behavior​

The activity writes the contents of the DataTable to the worksheet starting at the specified cell.

The required worksheet range is automatically determined based on the number of rows and columns in the DataTable.

Existing worksheet data within the destination area may be overwritten.

Outputs​

This activity does not produce any activity-specific outputs.

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