I have 5 different xlsx files in a folder and I will add new files every month. I want to read them at a same time with the same workflow but I don’t want to combine them. How can I do that?
In other words I want to read 5 xlsx files at the same time, do manipulation and want 5 different xlsx files in result with a single workflow.
I have some questions to create a good solution: are the manipulations on each file the same? Does the number of files you want to do some manipulation on starts with 5 and increases over time?