How to read the different sheet names in excel

Help
,
22

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

23

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

24

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

image
image1366×768 110 KB

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

1 Like
25

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
26

You’re welcome mate :wink:

1 Like
27

Hi,

Here is an activity to get all the sheets name

Regards
Balamurugan.S