C#合并Excel文档,出自:https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Merge-Merge-Excel-Files-into-One-with-C-VB.NET.html Workbook newbook = new Workbook(); newbook.Version = ExcelVersion.Version2010; newbook.Worksheets.Clear(); Workbook tempbook = new Workbook(); string[] excelFiles = new String[] { "sample1.xlsx", "sample2.xlsx", "sample3.xlsx" }; for (int i = 0; i < excelFiles.Length; i++) { tempbook.LoadFromFile(excelFiles[i]); foreach (Worksheet sheet in tempbook.Worksheets) { newbook.Worksheets.AddCopy(sheet); } } newbook.SaveToFile("result.xlsx", ExcelVersion.Version2010);
Workbook newbook = new Workbook(); newbook.Version = ExcelVersion.Version2010; newbook.Worksheets.Clear(); Workbook tempbook = new Workbook(); string[] excelFiles = new String[] { "sample1.xlsx", "sample2.xlsx", "sample3.xlsx" }; for (int i = 0; i < excelFiles.Length; i++) { tempbook.LoadFromFile(excelFiles[i]); foreach (Worksheet sheet in tempbook.Worksheets) { newbook.Worksheets.AddCopy(sheet); } } newbook.SaveToFile("result.xlsx", ExcelVersion.Version2010);
110,535
社区成员
642,577
社区内容
加载中
让您成为最强悍的C#开发者
试试用AI创作助手写篇文章吧