Definition and Usage
Finds the first empty cell in the specified column and returns its row number. This command is useful for determining where to add new data in an Excel worksheet, especially when appending data to existing tables or lists.
Parameter Values
Input parameters
Parameter | Description | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on | Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Worksheet name | The name of the worksheet to search in | Yes | Leave blank to use the active worksheet |
Column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) | Yes |
|
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This command produces a numeric variable that contains the row number of the first empty cell in the specified column.
Using Variables in Conditions
You can use the output variable in subsequent actions to:
Reference the row where new data should be inserted
Determine the last occupied row in a data range
Calculate the total number of filled rows in a column
When using the variable in other commands, ensure you're referencing it as a numeric value since it represents a row number.
Notes
Before using this command, ensure that a valid Excel instance is open and the target worksheet exists.
The command searches from top to bottom in the specified column.
If the column contains no data, the command will return 1 (the first row).
If the column is completely filled with data, the command will return the first row after the last filled cell.
This command only detects truly empty cells; cells with formulas that return empty strings or zero values are not considered empty.