Excel unknown sheets name and numbers (Beginner level)

Help
,
1

Hi everyone.

I am trying to read an Excel file but I don’t know in advance the number of sheets the file contains nor the name of each sheet.

I can’t figure out how I can do that or even if it is possible to do that.

Thanks by advance for any help provided.

2

Hi,

Hope the following helps you.

img20200813-2
img20200813-21348×826 29.2 KB

Regards,

2 Likes
3

Can you please share the main file. I have an error stating sheet isn’t declared or accessible.

4

Hi,

Here you are.

Sample20200813-1.zip (20.7 KB)

Regards,

1 Like
5

Thank you for sharing the file and thank you for your help, I forgot about the variable when I tried to reproduce it.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.