Merge two different excel files into one excel file in c# RSS

• • Reply
  

  aykt87

  Member

  13 Points

  37 Posts

  Merge two different excel files into one excel file in c#

  Nov 02, 2010 07:58 AM|LINK

  Hi;

   

  I simply want to merge two excel files into another excel file. I guess i should use Intertor for that but i don't know how to use it, never use it before. May anyone help please... Thanks!

  • Moved by anas on Nov 02, 2010 08:22 AM
• • Reply
  

  Alpesh Patel

  Member

  618 Points

  155 Posts

  Re: Merge two different excel files into one excel file in c#

  Nov 02, 2010 08:30 AM|LINK

  Hi,

  1. Open excel to read

  2. create new sheet in different file.

  3. Read cell by cell from source and submitt it to newer one.

  4. do the same thing for other source and finally save file and close it.
  

  
  

  
  

  Thanks,
  
  Alpesh Patel
  http://www.radhesoftech.com
  • Marked as answer by aykt87 on Nov 11, 2010 08:54 AM
• • Reply
  

  jeeshen.lee

  Member

  4 Points

  2 Posts

  Re: Merge two different excel files into one excel file in c#

  May 14, 2012 05:10 AM|LINK

  Not c# code sample but in case you are looking for tool to merge excel files, i wrote a small app to do so, here's the link.

  http://jeeshenlee.wordpress.com/2010/09/23/jmc-excel-join-merge-combine-multiple-excel-sheets-or-excel-workbooks/

• • Reply
  

  tarwara99

  Member

  12 Points

  6 Posts

  Re: Merge two different excel files into one excel file in c#

  Apr 20, 2013 11:43 AM|LINK

  I guess it is too late to reply but I think people visiting this page can be benefitted with this macro.

  It can merge excel 2010, 07 and 03 files into one file. Just two shortcut keys and it will merge all your sheets.