本文将介绍如何使用Spire.XLS for Java将多个Excel文档合并为一个Excel文档。
import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
import com.spire.xls.WorksheetCopyType;
public class MergeExcels {
public static void main(String[] args) {
//将待合并Excel文档的名称保存至字符串数组
String[] inputFiles = new String[]{
"C:\\Users\\Administrator\\Desktop\\file1.xlsx",
"C:\\Users\\Administrator\\Desktop\\file2.xlsx"};
//创建一个新的Excel文档
Workbook newBook = new Workbook();
//清除默认的工作表
newBook.getWorksheets().clear();
//创建一个临时的Workbook对象
Workbook tempBook = new Workbook();
//遍历数组
for (String file : inputFiles)
{
//依次加载每个Excel文档
tempBook.loadFromFile(file);
//将文档中的所有工作表复制到新建的Excel文档中
for (Object obj : tempBook.getWorksheets())
{
Worksheet sheet= (Worksheet) obj;
newBook.getWorksheets().addCopy(sheet, WorksheetCopyType.CopyAll);
}
}
//保存新文档到指定路径
newBook.saveToFile("MergeFiles.xlsx", ExcelVersion.Version2013);
}
}
合并前:
合并后: