Skip to main content

Task Office - Excel - Hide/Unhide Worksheet​

The Excel - Hide/Unhide worksheet Task hides or shows a worksheet in an Excel file and saves the file afterwards.

Credentials

To control a remote computer you may need to use a Credential. The Credential must match the user name and password of the user that you want to login for. Select a Credential in the combo box or click the Settings icon to open Manage credentials in order to add or edit Credentials.

Select Excel file

Select the full path to the Excel file.

Password

Enter the password for the Excel file, if it is password protected.

Worksheet

Worksheet name

Select the worksheet to hide or unhide. Click the Get button to populate the list with worksheets from the selected file. The Task fails if no worksheet with this name exists.

State

  • Hide worksheet — Hides the worksheet.
  • Unhide worksheet — Makes a hidden worksheet visible again. This is the default.