Hello everyone,
I have many Excel files and each contains 4 sheets with same structure. I want an automated way to import 3 sheets from all of the Excel files. The sheets name are: Sheet_1, Sheet_2, Sheet_3, and Sheet_4. I don't want Sheet_4, only the first 3 sheets. The idea is to build a workflow so the next person will only need to run the workflow to have all of the data in one table.
Thanks in advance
Solved! Go to Solution.
this should be an old topic, but here the method.
provided all structure. (included same header name, header sorting, data type and the number of empty column)
even the sheetname data type...