muliple input excel to 1 Output file in Excel

Question

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 17-Apr-13 7:54am

Navas Khanj

Add a Solution

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

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Kenneth Haugland · Answer 1 · 2013-04-17T09:35:00

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.

Maciej Los · Answer 2 · 2013-04-17T10:40:00

Solution 2

See my past answers:
Creating a Macro to Copy Time sheets Data of employees into Master Sheet[^]
Vb.Net - Copying cells from from one Excel worksheet to another[^]

Posted 17-Apr-13 10:40am

Maciej Los

Sam.S129 · Answer 3 · 2013-04-17T21:35:00

Solution 3

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.

Posted 17-Apr-13 21:35pm

Sam.S129