ASP.NET

How to merge Two Different Excel sheets? RSS

4 replies

Last post Apr 20, 2013 11:56 AM by tarwara99

‹ Previous Thread|Next Thread ›

- Reply
ravikirantum...

Member

60 Points

140 Posts

How to merge Two Different Excel sheets?

Mar 17, 2011 11:58 PM|LINK

Hi,

How do i write a programme to merge Two different excel docs(Columns are different in two sheets) into one excel sheet?

For instance, Excel1.xslx has a and b columns

Excel2.xslx has c and d columns

Now i want to combine those two excel documents and create excel 3 with a,b,c,d columns
- Moved by mbanavige on Mar 18, 2011 01:02 AM
- Edited by ravikirantummala2000 on Mar 18, 2011 01:52 AM
- Reply
aptomar

Participant

1227 Points

225 Posts

Re: How to merge Two Different Excel sheets?

Mar 18, 2011 02:10 AM|LINK

write VBA macro in excel and call it from your c# code.

Hope this answer your question

Please mark as answer if this solve your problem

DevTechie.com
- Reply
ravikirantum...

Member

60 Points

140 Posts

Re: How to merge Two Different Excel sheets?

Mar 18, 2011 02:20 AM|LINK

how do i do that?
- Reply
aptomar

Participant

1227 Points

225 Posts

Re: How to merge Two Different Excel sheets?

Mar 18, 2011 02:22 AM|LINK

This article will help you understand

http://support.microsoft.com/kb/306683

Hope this answer your question

Please mark as answer if this solve your problem

DevTechie.com
- Marked as answer by Vince Xu - MSFT on Mar 25, 2011 08:29 AM
- Reply
tarwara99

Member

12 Points

6 Posts

Re: How to merge Two Different Excel sheets?

Apr 20, 2013 11:56 AM|LINK

Hi Ravi, You can download excel macro sheet from this blog. It is also not password protected so you can resuse this code.