Skip to content

Set Sheet Visibility Activity

The Set Sheet Visibility activity allows users to programmatically control the visibility of specific worksheets within an Excel workbook. This is useful for hiding sensitive data sheets, calculation sheets, or showing specific reports based on workflow logic.

Field Description Requirement
Excel name Specifies the reference name of the Excel instance to be modified. Required
Sheet name Defines the name of the worksheet whose visibility status will be changed. Required
Visibility Sets the visibility state of the sheet. Options typically include VISIBLE or  HIDDEN. Optional

Action Types & Examples

VISIBLE

  • Format: string
  • Example Result: The specified worksheet becomes visible and selectable in the Excel taskbar.

HIDDEN

  • Format: string
  • Example Result: The worksheet is hidden from view but can be unhidden manually by a user in Excel.

Implementation Examples

Field Setup

  • Excel name: FinancialReport
  • Sheet name: Internal_Calculations
  • Visibility: HIDDEN

Execution Parameters

  • Target Instance: FinancialReport
  • Action: The sheet named Internal_Calculations is removed from the user's view while remaining accessible to the robot.