Merging 9 excels into 9 sheets in one excel

Hi Team,

I have 9 excels in one folder and 10 in another folder. By using UiPath bot I need to merge those 9 excels into 9 sheets in one excel and same for 10 excels into 10 sheets into one excel. Please help me with solution.

Thanks in Advance,

Hi,

Can you try the following steps?

First, get filenames of xlsx using System.IO.Directory.GetFiles method.

Next, iterate its files using ForEach activity.

Then use ExcelApplicationScope and CopySheet activity in the loop.

Regards,

2 Likes