Get Next Empty Row Spreadsheet Action

Get Next Empty Row Spreadsheet Action scans a specified worksheet of an open spreadsheet and finds the index of the first completely empty row (i.e., row with no cells containing values).

Appearance

In Talos, Get Next Empty Row Spreadsheet Action appears as a standard rectangular node with a horizontal spreadsheet row and an arrow icon.

Properties

As with all Actions, Get Next Empty Row Spreadsheet Action has a set of unique properties required for its functionality.

Common properties

Common properties inherited from Action.

Display NameString

This is the display name of the action.

By customizing this property, you can differentiate between same-type actions.

Action IDString

Indicates the unique ID of this action.

This property is Read only and it is not customizable

DisabledBoolean

If set to true, this action is considered disabled and will not be executed.

Document VariableString

The variable containing the open Excel spreadsheet document.

Must reference a spreadsheet variable opened by a preceding Open Spreadsheet Action.

WorksheetString

The name of the specific worksheet to scan.

Provide the exact name of the sheet (e.g., "Sheet1").

Output VariableString

The name of the variable to store the next empty row index.

Stores the next empty row index as an RPA Integer. Extremely useful for appending new rows of data without overwriting existing entries.