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

[caduque (Cedric)]

Hi!

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

[Srini84 (Srinivas)]

@caduque

Check attached for your reference

ExcelMergeAndFormat.zip (41.9 KB)

Mark as solution if this helps

Thanks

[ImPratham45 (Prathamesh Patil)]

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

[balupad14 (Balamurugan)]

input sources

Data1.xlsx

Data2.xlsx

Data3.xlsx

Final Result (ProcessData.xlsx)

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

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Cedric.zip (75.8 KB)

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

Configure Package in UiPath

Thank you
Balamurugan.S