In daily work, to facilitate the doucment management, we can merge multiple Files into a Single File. Today, this article will introduce how to merge multiple Excel documents into a single document using Java.
1# You need to import the jar dependency of a free Java Excel API
Method 1: Download the free API (Free Spire.XLS for Java) and unzip it, then add the Spire.Xls.jar file to your project as dependency.
Method 2: Directly add the jar dependency to maven project by adding the following configurations to the pom.xml.
<repositories>
<repository>
<id>com.e-iceblue</id>
<name>e-iceblue</name>
<url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>e-iceblue</groupId>
<artifactId>spire.xls.free</artifactId>
<version>3.9.1</version>
</dependency>
</dependencies>
2# A screenshot of two Excel documents that need to be merged
3# Relevant code snippet
import com.spire.xls.*;
import com.spire.xls.core.IWorksheet;
public class MergeExcels {
public static void main(String[] args){
//The input Excel files
String[] inputFiles = new String[]{"Data1.xlsx","sample3.xlsx"};
//Create a new workbook
Workbook newBook = new Workbook();
//Clear all worksheets
newBook.getWorksheets().clear();
//Create another workbook
Workbook tempBook = new Workbook();
//Loop through the Excel files, copy worksheets in each Excel file into the new workbook
for (String file : inputFiles)
{
tempBook.loadFromFile(file);
for (Object sheet : (Iterable)tempBook.getWorksheets())
{
newBook.getWorksheets().addCopy((IWorksheet) sheet, WorksheetCopyType.CopyAll);
}
}
//Save the result file
newBook.saveToFile("MergeFiles.xlsx", ExcelVersion.Version2013);
}
}
Top comments (0)