Get Next Empty Column Spreadsheet Action

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

Appearance

In Talos, Get Next Empty Column Spreadsheet Action appears as a standard rectangular node with a vertical spreadsheet column and an arrow icon.

Properties

As with all Actions, Get Next Empty Column 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 column identifier.

Stores the next empty column identifier (e.g., index/number) as an RPA Integer or letter string.