Row and column operations in Excel advanced

The Excel advanced package contains various actions that you can use to automate tasks related to the row and column operations in a Microsoft Excel spreadsheet.

Row and column actions in the Excel advanced package

The Excel advanced package includes the following actions:

Action Description
Get column name See Get column name action
Get row number See Get row number action
Hide rows/columns in selection See Hide rows/columns in selection action
Insert/Delete Rows/Columns See Using Insert/Delete rows/columns action.
Read column See Read column action
Read row See Read row action
Remove blank rows See Remove blank rows action
Select cell(s)/row(s)/column(s) See Using Select action for cells, rows, and columns.
Unhides rows/columns in selection See Unhides rows/columns in selection action