Get First Empty Row/Column
Description
The Get First Empty Row/Column activity identifies the first empty row and first empty column within a worksheet.
This activity is commonly used to determine the next available row or column for inserting data into a worksheet.
Common Capabilities
Process Data Support
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
Optional range used to limit the search area.
Learn more → Worksheet Data Selection
Examples:
A1:D100A:A1:100B2:F50
When not specified, the entire worksheet is evaluated.
Behavior
The activity evaluates the specified range, or the entire worksheet when no range is provided, and returns:
- The first empty row.
- The first empty column.
The returned values are zero-based indexes.
Outputs
Row Index
Returns the zero-based index of the first empty row.
Examples:
| Value | Row |
|---|---|
| 0 | First row |
| 1 | Second row |
| 2 | Third row |
Column Index
Returns the zero-based index of the first empty column.
Examples:
| Value | Column |
|---|---|
| 0 | A |
| 1 | B |
| 2 | C |
Wait All Incoming
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
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include Fault, Continue, Suspend, and Retry.