Hi!
I have 3 excel files (same headers) and I need to insert them all to a single, already existing file.
Hi!
I have 3 excel files (same headers) and I need to insert them all to a single, already existing file.
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
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
Cedric.zip (75.8 KB)
Here is a video that how to configure the local package into the project.
Thank you
Balamurugan.S