Get List of Visible/Active worksheets in Excel

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.


1 Like

Please search before posting

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

1 Like

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.


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.

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