How to skip the hidden sheet in excel

[Prasaanth_S1 (Prasaanth S)]

Hi,

I need to skip the hidden sheet in excel,
(eg: Sheet 2 is hidden, and I need to proceed with only Sheet 1 & Sheet 3).
Am using the “Get workbook sheet” activity, but it will read all three sheets.
In the future, the sheet name & count of sheets may increase.
If the sheet is hidden, the BOT should not read the hidden sheet.

Any suggestion !!

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @Prasaanth_S1
You can check out this thread

How to get the visible sheets in excel?

Using a “Get workbook Sheets” Activity can get all sheet names, but I don’t want to get the hidden sheets. Does anyone have a good solution to this problem? Thanks a lot.

Cheers.

[arjunshenoy]

Hi @Prasaanth_S1

There is a component in the market place, check this out:

Get Visible Only Worksheets - RPA Component | UiPath Marketplace

Hope this helps,
Best Regards.

[Yoichi]

HI,

Can you try the following sample using ClosedXML?

workbook = new ClosedXML.Excel.XLWorkbook(filename)

Then

visibleworksheets = workbook.Worksheets.Where(function(s) s.Visibility=XLWorksheetVisibility.Visible).Select(Function(s) s.Name).ToArray

Sample20230320-3L (2).zip (10.3 KB)

Regards,

[Yoichi]

FYI another approach:

Modern ForEachExcelSheet will skip hidden sheet.

Regards,