How to read all sheets in a excel file



Hi everyone,

I am working on a project which reads input value from excel file and put into a web app. The excel file contains many sheets and I need to loop all of them to get input value. I don’t know the way to read all sheets in an excel file.
If you have any solution for this, please help me.

thanks and best regards
Hoang Anh.



Try to search before posting. There’re some topics about the same question that you are asking for.

Here’s some examples that may help you:

Hope It Helps.



thank you so much for your information.
It’s very helpful for me.


No problem :slight_smile:

Let us know if worked!



It’s so late now, so I will check it tomorrow and let you know if it works.