Excel

  • 92 Views
  • Last Post 31 January 2020
padmini@mindmapconsulting.com posted this 31 January 2020

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

alphonsa@intellibot.io posted this 31 January 2020

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