Dear friends, once again I am asking for help. I have the following task: There are several excel files in a folder. Each file has several sheets. Some sheets have similar structures, some are unique I need to Read files and sheets (done with Read Excel Sheet Names + Table Row to Variable Loop + Excel Reader) BUT I can’t store multiple tables with different structures within a loop. Likely there’s a possibility to add all columns from every sheet of every table and then somehow separate them, but is it the only possible (and in fact not easy) solution… Thank you very much for your help!

Reading multiply Excel Files with several sheets

mlauber71 May 29, 2021, 12:30pm 2

@DmitryIvanov76 you might want to explore these various examples of workflows to import Excel files in a lot of scenarios.

If this is not what you are looking for one way could be to create a sample workflow that would represent your challenges without giving away sensitive data.

3 Likes