Hide or Show Activity

The Hide or Show activity enables users to control the visibility of specific rows or columns within an open Microsoft Excel file. This activity facilitates dynamic presentation of data by allowing you to hide sensitive information or show relevant sections as needed.

Field	Description	Requirement
Excel name	The reference name of the Excel file that has already been opened or created.	Required
Sheet name	The name of the sheet within the Excel file to perform the operation.	Optional
Sheet index	The index of the sheet within the Excel file to perform the operation.	Optional
Action	Specifies whether to hide or show the selected rows or columns.	Required
Rows	Defines the specific row or range of rows to be hidden or shown.	Optional
Columns	Defines the specific column or range of columns to be hidden or shown.	Optional

Action Types & Examples

HIDE

Format: string
Example Result: HIDE

SHOW

Format: string
Example Result: SHOW

Implementation Examples

Field Setup

Excel name: ${newExcel}
Sheet name: Sheet1
Sheet index: 5

Execution Parameters

Action: HIDE
Action: SHOW
Rows: 1
Rows: 1:5
Columns: 1
Columns: 1:4

Technical Notes

If the Sheet name or Sheet index fields are not provided, the activity defaults to operating on the first sheet in the Excel file. If the Rows field is left blank, the activity will perform the operation for the whole column(s) specified.