Hide or show

Estimated reading: 1 minute 119 views

Hide or show activity is used for hiding or showing a column or a row in an Excel file.

*Excel name	The name of the Excel file that was opened or created before is selected.
Sheet name	Name of the sheet to work in Excel. If not added, it takes the first sheet by default.
Action	Hide and show rows or columns.
Rows	Which row will be shown or hidden.
Colums	Which column will be shown or hidden.

_{Note: * Fields selected with are required, others are optional.}

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Action as shown in the example.

HIDE

SHOW

You can use the Rows as shown in the example.

1:5

You can use the Rows as shown in the example.

1:4

If Row field is left blank, it will perform the operation for the whole column.