How to read the different sheet names in excel

That is weird because it works perfectly fine for me when using .xlsx files! :thinking::thinking:

It works fine for .xlsx and .xlsm, error comes for .xls file
Sorry for bothering.

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

for hidden sheet problem refer to this, might help you :smiley:

1 Like

Thanks a lot for sparing your time, there must b some problem with that particular excel file of mine, i will sort it out.

Thanks again :slight_smile:

1 Like

You’re welcome mate :wink:

1 Like


Here is an activity to get all the sheets name