Loading of all sheets from .xlsx

Hi dears,

I am looking for an option to load each sheet from an excel, no matter of naming or number.
Each month I am loading excel workbooks, with several sheets. Some month the excel consists 13, other month 15 sheets and some sheets may be missing one month and appearing the next month. The naming of columns is identical in each sheet. Nowadays I am checking manually, if each sheet has been loaded, but I would like to automate it. What is the workaround? I was trying through iteration, but didn’t work well. Thanks in advance!

Hi,

you can first list all sheets of the file and iterate over the sheet names. The “Excel command” action could help.

Kind regards,

Jochen

worksheets.xlsx (12.1 KB)
worksheets.morph (4.4 KB)
Here it is. I hope it is what you are looking for.

Hi both,
thanks a lot for your assistance, I think I have to figure out more deep, how this iteration works, but your advise helped out a lot! :slight_smile:

1 Like