How to hide the multiple excel sheets

Help Studio
, ,
1

Hi, Im new here. can anyone help me how can we hide the excel sheets in uipath. i dont see any activities from uipath for this.

(Yes, there is balareva activities, but im not allowed to use any activities, which are not defined (or given by my org).

Thanks and regards

2

Hi @gopal_ram

Welcome to UiPath Forum.

Please use the below steps.

You can hide sheets one by one.

To HIDE:.Use Send Hot Key as Alt+o+h+h to hide the sheet
To UNHIDE: Use send hot key as Alt+o+h+u to unhide the same

Hope this will be useful. Thank you.

3

If you like to do this programmatically, please refer the below.

Thank you.

4

Hi @Jobin_Joy , Do you mind if you have Xml file to share ?

5

Hi @gopal_ram ,

As @Jobin_Joy rightly pointed out, you can use VBA code to hide and unhide the sheets.

There is a video in YouTube please check out , you will get an idea. The video is basically for single sheet, but if you want to work for multiple sheet, then enclose the logic in for each loop.

Way 1 :

For each loop ---- This is for Sheets
use the workflow created in the video

Way 2:
Modify the code, by looping each sheets in VBA or vb.net

6

Hi can you explain more on the multiple sheet ?

7

@gopal_ram Please find the attached workflow in the zip file,
Excel_HideSheets.zip (12.8 KB)

Hope this may help you :slight_smile:

8

Hi @gopal_ram

Here is the sample for getting sheet names from an excel file.

Code:
hide sheet.xaml (6.9 KB)
Test.xlsx (10.9 KB)

Then you can follow the steps mentioned by @pavithra_pavi

Thank you.