当前位置：文江博客话题详情

如何将三个Excel工作表放在一个工作簿下

发布于 2024-09-14 07:15:28 字数 37 浏览 12 评论 0原文

我有三个 Excel 工作表，我想将它们合并到一个工作簿下。

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

╰◇生如夏花灿烂 2024-09-21 07:15:28

如果您需要在 C# 中执行此操作，请查看将 Excel 文件合并为一个一些想法。

您将需要 Microsoft Excel Interop 库。我在 http://forums.asp.net/p/1457463/ 找到以下示例3498328.aspx

ApplicationClass excelApplicationClass = new ApplicationClass();
_Workbook finalWorkbook = null;
Workbook workBook = null;
Worksheet workSheet = null;
Worksheet newWorksheet = null;

// Open or create destination WorkBook
finalWorkbook = excelApplicationClass.Workbooks.Open("dest.xlsx", ...);

//Open the source WorkBook
workBook = excelApplicationClass.Workbooks.Open("src.xlsx", ...);

//Open the WorkSheet
workSheet = (Worksheet)workBook.Sheets[1];

int countWorkSheet = finalWorkbook.Worksheets.Count;

newWorksheet = (Worksheet)finalWorkbook.Sheets[countWorkSheet];
workSheet.Copy(Missing.Value, newWorksheet);   //Copy from src to destn

finalWorkbook.Save();
workBook.Save();

搜索 Excel.Workseet.Copy() 方法。这应该会让您沿着所需的代码路径前进。

祝你好运！

If you need to do this in C#, have a look at Merge Excel Files Into One for some ideas.

You will need the Microsoft Excel Interop library. I found the following example at http://forums.asp.net/p/1457463/3498328.aspx

ApplicationClass excelApplicationClass = new ApplicationClass();
_Workbook finalWorkbook = null;
Workbook workBook = null;
Worksheet workSheet = null;
Worksheet newWorksheet = null;

// Open or create destination WorkBook
finalWorkbook = excelApplicationClass.Workbooks.Open("dest.xlsx", ...);

//Open the source WorkBook
workBook = excelApplicationClass.Workbooks.Open("src.xlsx", ...);

//Open the WorkSheet
workSheet = (Worksheet)workBook.Sheets[1];

int countWorkSheet = finalWorkbook.Worksheets.Count;

newWorksheet = (Worksheet)finalWorkbook.Sheets[countWorkSheet];
workSheet.Copy(Missing.Value, newWorksheet);   //Copy from src to destn

finalWorkbook.Save();
workBook.Save();

Do a search for the Excel.Workseet.Copy() method. This should get you going down the needed code path.

Good luck!

回复收藏 0 原文