This action specifies a column in the active worksheet and retrieves the first empty row in that column.
This is a column-specified version of Get first free column/row from Excel worksheet Action.
This action is useful when there are multiple tables on the same sheet and you want to specify which empty row is which.
If there are multiple sheets, since the target to retrieve is the active sheet,
If you have multiple sheets, you should specify the sheet(s) in the Set active Excel worksheet Action.
How to use.
Specify the target Excel file.
Retrieves from the specified column. 1 for column A, 3 for column C, and 4 for column D.
Specify 3 to target column C.
If you execute the action on the table below, the result will look like this (yellow is blank)
Sets the index of blank row.
Error handling if necessary.
An error occurs if the retrieval fails for some reason, such as an invalid column specification.
For those who want to learn Office script effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.