Get Last Empty Cell
Description
The Get Last Empty Cell activity locates the last empty cell within a specified row or column of a worksheet.
This activity is commonly used to identify the final available position within a row or column before existing data begins.
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
Column Name
Column identifier used to search for the last empty cell within a column.
Examples:
- A
- B
- C
- AA
Column names are not case-sensitive.
Row Number
Row number used to search for the last empty cell within a row.
For example:
| Value | Row |
|---|---|
| 1 | First row |
| 2 | Second row |
| 3 | Third row |
Behavior
Specify either a Column Name or a Row Number.
When a column is specified, the activity scans the column and returns the last empty cell found within that column.
When a row is specified, the activity scans the row and returns the last empty cell found within that row.
If both values are provided, activity behavior is implementation-specific and should be avoided unless explicitly required.
Outputs
Cell Address
Returns the address of the last empty cell that was found.
Examples:
- A10
- B25
- AA5
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.