Skip to main content

Get Last Empty Row Column

Description​

This activity gets the last empty row and column in the active sheet 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 last 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 find the last empty row and column. By default, the range is the entire sheet.
  • Sheet Name - The sheet name where you want to get the last 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 – Returns the column index of the last empty zero-based on the active spreadsheet of the specified Excel spreadsheet.
  • Row Index – Returns the row index of the last empty zero-based on the active spreadsheet of the specified Excel spreadsheet.

Example​

Correlation Scope

Download Example