Count the Number of Worksheets in Excel Using Java

In Microsoft Excel, suppose a workbook contains lots of worksheets and you need to count them, you can use the Sheets Function, the Define Name Command or a simple VBA code to achieve it. Within this tutorial, I’ll show you how to programmatically count the number of worksheets in Excel using a free Java API.

Import the Jar Dependency

Method 2: Directly add the jar dependency to maven project by adding the following configurations to the pom.xml.


Sample Code

  • Create a Workbook instance.
  • Load a sample Excel document using Workbook.loadFromFile() method.
  • Get the number of worksheets using Workbook.getWorksheets().getCount() method.
import com.spire.xls.Workbook;

public class CountNumberOfWorsheets {
public static void main(String[] args) {
//Create a Workbook instance
Workbook workbook = new Workbook();

//Load a sample Excel file

//Get the number of worksheets
int sheetCount=workbook.getWorksheets().getCount();

//Output the result
System.out.println("The number of sheets is "+sheetCount);



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store