I have a sequence that can read ranges from an excel and then store it as a Data Table, I do all these under the ‘Excel Scope Application’ but I specify the filename and sheetname.
How can I automate the sequence to operate on the following scenarios:
I need this sequence to work on all the excel sheets in a particular local folder, the excel sheets can fall under the 2 below:
- Folder contains multiple excel files with different names - but consistent sheet names
- Folder contains multiple excel files with different names - but different sheet names