How to read all sheets in a excel file

excel
activities

#1

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.


#2

Hello!

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.

Regards,


#3

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


#4

No problem :slight_smile:

Let us know if worked!

Regards,


#5

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