Get First Empty Cell
Description
The Get First Empty Cell activity locates the first empty cell within a specified row or column of a worksheet.
This activity is commonly used to determine the next available location for inserting data into a worksheet.
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 first 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 first 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.
The activity finds the first cell without data in the selected row or column. An entirely empty row/column returns its first position. If no empty position is available, Cell Address is an empty string.
This can locate a gap inside existing data; it is not necessarily the position after the final populated cell.
Outputs
Cell Address
Returns the address of the first 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 First Empty Cell returns A2. Bind Cell Address to a subsequent cell-address input only after checking it is populated.