Hide or Show Activity

The Hide or Show activity enables users to control the visibility of specific rows or columns within an Excel spreadsheet. This activity allows for either hiding or displaying selected ranges of data, enhancing data presentation and focus.

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 to perform the action on. If not specified, the activity defaults to the first sheet.	Optional
Sheet Index	The index of the sheet to perform the action on. If not specified, the activity defaults to the first sheet.	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. Can be a single row number (e.g., `1`) or a range (e.g., `1:5`).	Optional
Columns	Defines the specific column or range of columns to be hidden or shown. Can be a single column number (e.g., `1`) or a range (e.g., `1:4` or `A:C`).	Optional

Action Types & Examples

Excel Name

Format: [string]
Example Result: "{newExcel}"

Sheet Name

Format: [string]
Example Result: "Sheet1"

Sheet Index

Format: [digit]
Example Result: "5"

Action

Format: [string]
Example Result: "HIDE"

Rows

Format: [string]
Example Result: "1:5"

Columns

Format: [string]
Example Result: "1:4"

Implementation Examples

Field Setup - Excel Name - Sheet Name - Sheet Index - Action - Rows - Columns

Execution Parameters - Excel Name: myWorkbook - Sheet Name: Sheet1 - Action: HIDE - Rows: 1:5

Technical Notes

If the Rows field is left blank, the activity will perform the hide or show operation for the entire column(s) specified in the Columns field.