Get List of Visible/Active worksheets in Excel

[kjana83 (Jana)]

Hi, how to get list of visible worksheet names. UiPath.Excel.WorkbookApplication.GetSheets() gives all the sheet names. And what are the members of UiPath.Excel.WorkbookApplication object.

Thanks
Jana

[richarddenton]

Please search before posting

How to read sheet name of an excel file

Hello @piyush.2224 Firstly you have to use “Excel application scope” activity to get the workbook from your excel file. Then, you can obtain all the sheets names of the excel with workbook.GetSheets. [image]

[kjana83 (Jana)]

Hi @richarddenton, I do not want all the sheet names. I want only “Visible” sheet names. there are many sheets hidden in the excel.

[richarddenton]

That’s an interesting one. I don’t think that you can determine whether they are visible or not. Do you have control of the sheets? i.e. could you mark Cell Z1 with the word visible to determine that it is indeed a visible sheet? Then do a check in UiPath?

I’m assuming you don’t know the names of the sheets otherwise you could read them in specifically.

RD

[kjana83 (Jana)]

I do not have control on the Excel. By the way, How can I get all the members of UiPath.Excel.WorkbookApplication. Introp.Excel.Workbook or Application members are not able to access here.

[DAishwarya (AishwaryaDesai)]

Hi , Is there any solution for reading only visible/Active sheets of an excel.