Skip to main content

Get First Empty Row Column

Description​

This activity gets the first empty row and column in the active spreadsheet of the specified Excel Workbook.

info

An empty row or column is where all the cells of that row or column are empty.

Properties​

Input​

  • Spreadsheet – Specify the Excel workbook instance to get the first empty row and column.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – By default, activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Optional​

  • Range - Specify the range of cells to search for the first empty row and column. By default, the range is the entire sheet.

  • Sheet Name - The sheet name where you want to get the first empty row and column. By default, the operation will be performed on the currently active sheet.

  • Continue On Error – Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False.

note

If this activity is included in Try Catch and the value of this property is True, no error is caught when the project is executed.

Output​

  • Column Index – Identifies the first empty zero-based column index of the active spreadsheet of the specified Excel Workbook.
  • Row Index – Identifies the first empty zero-based row index in the active spreadsheet of the specified Excel Workbook.

Example​

Download Example

Get First Empty Row Column