多个输入excel到Excel中的1个输出文件 [英] muliple input excel to 1 Output file in Excel

问题描述

亲爱的所有



如何将多个输入Excel文件输出到单个输出文件





例如

Excel 1：

Sheet1

名称年龄

AAA 10



Excel 2



Regno性别

A11 M





我期待输出像这样



Excel输出

< br $>
Regno名称性别年龄

A11 AAA M 10



请告诉我

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

推荐答案

查看Microsoft提供的文档。 Yu应该能够在那里找到你问题的答案：

http://support.microsoft.com / kb / 301982 [ ^ ]



如果您对Excel有任何疑问，您应该启动一个记录宏，做你需要做的事情，并停止宏。如果您查看代码，应该直接在VB.NET中实现它。

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.

查看我过去的答案：

创建宏以复制时间表员工数据到主表 [ ^ ]

Vb.Net - 将单元格从一个Excel工作表复制到另一个工作表 [ ^ ]

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[^]

您好，



我认为您需要将Excel 1中的数据复制到Excel 2.



请看看<啊ref =http://excelcsharp.blog.com/2013/01/22/excel-copy-copy-excel-sheet-in-different-cases-with-c-vb-net/>这篇文章。它可能对您有所帮助。

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.

这篇关于多个输入excel到Excel中的1个输出文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！