Excel

  • 42 Views
  • Last Post 3 weeks ago
padmini@mindmapconsulting.com posted this 3 weeks ago

How to merge data from two different excel sheet and paste in to new excel sheet

alphonsa@intellibot.io posted this 3 weeks ago

Hi Padmini,

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

https://intellibot.io/forum/thread/issue-while-reading-from-excel-file-using-datareader/

Thanks & Regards

Alphonsa 

Close