Multiple excel file with diffrents names

Ok, I’m pretty sure that you still can do this using VBA but lets try with UiPath.

I would proceed like this :

First extract the first excel file with a read range to a first DataTable.
I’ll do the same with the second excel file.

And then use two for each row to loop through the two extracted DataTable and push the content on your new excel file.

Create and fill a new Excel file with WriteRange from Excel Activity :

1 Like