Get List of Visible/Active worksheets in Excel

excel

#1

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


#2

Please search before posting


#3

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


#4

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


#5

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.