Multiple Excel consolidation

Learning Initatives Reboot Your Skills 2021
1

Hi All,

I have to copy daily data from multiple excel files into master excel book. the master excel book have various sheet. data need to copy from multiple excel file into respective sheet in master file. when i use datatable activity, i am loosing the formats and graps and other images in the master excel book, but i want to retain master book formating/charts/images. help me here how to achieve.

2

Hi,
Please find the attached sample workflow. You can get some idea on logic
Here I have created sheet names in master excel dynamically. If you want to write the data in particular sheets you have to map the sheet name according to your input data.

Please provide your sample workflow if you have any issues

Mark as solution if it helps
ReadMutilpleExcelsToOneMasterExcel.zip (40.3 KB)

3

I am using UIPATH 2018.4.3, not able to open your sample script