Man illustrationFlower illustration

Docy

Hide or show

Estimated reading: 1 minute 63 views

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


*Excel nameThe name of the Excel file that was opened or created before is selected.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
ActionHide and show rows or columns.
RowsWhich row will be shown or hidden.
ColumsWhich 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

1:5

You can use the Rows as shown in the example.

1

1:4

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

CONTENTS