I am currently working on a flow that reads in an excel file, writes the data to a data table, then appends the data to an excel worksheet. It works great with a single file. However, I am wanting to repeat this flow for each excel file within a folder. But, each attempt to add a “For Each” activity, I cannot get the excel application scope activity to work, thus making the flow fail.
How can I run this flow for each file in a specific folder?
Here is the uipath file: Flowchart.xaml (16.3 KB)
Two example input excel files stored that are stored the same folder (first Excel Application Scope activity reads these two excel workbooks):
DEP_1101_TRAN1.xlsx (16.4 KB) DEP_1101_TRAN2.xlsx (16.4 KB)
The desired output excel workbook result (second Excel Application Scope activity appends):
combined_dep_result.xlsx (17.0 KB)