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 settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
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 exactly one of Column Name or Row Number. Row numbers are 1-based; column letters use Excel notation.
Normally, the activity returns the position immediately after the last used cell in the selected row or column. If the last worksheet position is already used, it searches backward for an empty cell. An entirely empty row/column returns its first position; if no empty cell is available, the result is an empty string.
Use Get First Empty Cell when the desired result is the first gap inside existing data.
Outputs
Cell Address
Returns the address of the last empty cell that was found.
Examples:
- A10
- B25
- AA5
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.
Example: Search column A
Set Column Name to A and leave Row Number empty. If A1 and A3 contain data and A2 is empty, Get Last Empty Cell normally returns A4, after the last used position. Bind Cell Address to a subsequent cell-address input only after checking it is populated.