How to read the different sheet names in excel

[Niket_Ghai]

Works exactly same for me as it did worked for .xlsx!

for hidden sheet problem refer to this, might help you

How to read sheet name of an excel file

Hey @niridi You can also get the hidden sheet name as well form Excel Workbook Object. Test.xlsx (10.9 KB) hidden sheet.xaml (6.9 KB) IN the above excel Sheet2 and Sheet6 are hidden. when you will run the sample still u will be able to get those sheet name with other visible sheet name as well. Regards…!! Aksh