When you want to find the specific worksheet quickly from several Excel workbooks that containing a lot of data, you may need to get the names of these worksheets first. This article will introduce a time-saving method to get worksheets names without opening the workbook. (API: Free Spire.XLS for Java)
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>
Relevant Code Snippet
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
public class GetWorksheetName {
public static void main(String[] args) {
//Create a Workbook object
Workbook wb = new Workbook();
//Load a sample Excel file
wb.loadFromFile("report.xlsx");
//Loop through the worksheets
for (Object sheet: wb.getWorksheets()
) {
//Get worksheets names
String sheetName = ((Worksheet) sheet).getName();
System.out.println(sheetName);
}
}
}
Top comments (0)