How to merge data from two different excel sheet and paste in to new excel sheet
- 60 Views
- Last Post 31 January 2020
Please refer to the screenshot below on how to merge excels into a new excel sheet using DataReader. This automation gets the files from a defined path and loops thru each excel file and reads data and writes to output file. WriteToExcel component appends the data into the defined excel path.
Note: In order to use Data Reader methods you should have OleDB installed in the machine, please refer to the below link for more information on OleDB
Thanks & Regards