Click here to Skip to main content
15,846,211 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Dear All

How to make muliple input Excel file to single output file


For Example
Excel 1:
Sheet1
Name Age
AAA 10

Excel 2

Regno Sex
A11 M


I Expect OUTPUT Like this

Excel Output

Regno Name Sex Age
A11 AAA M 10

Please Tell me
Posted
Comments
Richard C Bishop 17-Apr-13 13:59pm    
You must attempt something first and then ask a specific question about an issue you are having. This is not a clear question, but more like a request for code. Just read the two files and store them in a datatable and then write another file or write to the screen using the values from the databales.
Kenneth Haugland 17-Apr-13 14:11pm    
So open and read the excel files into memory and than print it to a new excel file. Sounds pretty straight forward if you ask me.
DinoRondelly 17-Apr-13 15:18pm    
This should be the answer

Have a look at the documentation provided by Microsoft. Yuo should be able to find an answer to your question there:
http://support.microsoft.com/kb/301982[^]

If you have any more questions regarding Excel you should just start a record macro, do the things you need to do, and stop the macro. If you look at the code it should be straight forward to implement it in VB.NET.
 
Share this answer
 
Hello,

I think that you need to copy data from Excel 1 to Excel 2.

Please have a look at this post. It may be helpful for you.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900