3 excel files with same headers but different data, needed to be inserted on an existing excel file

Hi!

I have 3 excel files (same headers) and I need to insert them all to a single, already existing file.

1 Like

@caduque

Check attached for your reference

ExcelMergeAndFormat.zip (41.9 KB)

Mark as solution if this helps

Thanks

U can use Read Range in Excel application scope for all files then in that use Append Range for master excel file it will append all the data from that excel to Master

input sources

Data1.xlsx

image

Data2.xlsx

image

Data3.xlsx

image

Final Result (ProcessData.xlsx)

Please update the latest version package (22.0.0) . In Uipath Market Place has 20.10.1

Cedric.zip (75.8 KB)

Here is a video that how to configure the local package into the project.

Thank you
Balamurugan.S

1 Like