This article will give two examples of how to insert and remove worksheet with a free Java API--Free Spire.XLS for Java.
1# Installation
Method 1: Download the free API and unzip it, then add the Spire.Xls.jar file to your project as dependency.
Method 2: You can also 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# The input Excel Workbook with three sheets:
3# Add a worksheet to an existing Excel workbook in Java:
import com.spire.xls.*;
public class AddWorksheet {
public static void main(String[] args) throws Exception {
String inputFile = "file1.xlsx";
String outputFile = "AddWorksheet.xlsx";
//Create a workbook and load a file
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile);
//Add a new worksheet named "AddedSheet"
Worksheet sheet = workbook.getWorksheets().add("AddedSheet");
sheet.getCellRange("C5").setText("This is a new sheet.");
//Save the Excel file
workbook.saveToFile(outputFile, ExcelVersion.Version2010);
}
}
4# Remove a worksheet from Excel workbook in Java:
import com.spire.xls.*;
public class RemoveWorksheet {
public static void main(String[] args) throws Exception {
String inputFile = "file1.xlsx";
String outputFile = "RemoveWorksheet.xlsx";
//Create a workbook and load a file
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile);
//remove the second worksheet
Worksheet sheet1 = workbook.getWorksheets().get(1);
sheet1.remove();
//Save the Excel file
workbook.saveToFile(outputFile, ExcelVersion.Version2010);
}
}
Top comments (0)