BE THE CODER > Excel > Java Excel API Examples > How to get Excel Workbook Sheet by index

Java Excel API is an open source java library to read, write and modify Excel spread sheets. This requires the library jxl-2.6.12.jar to be in classpath. The following example shows how to get the Excel workbook spread sheet by its index.

File Name :	com/bethecoder/tutorials/jexcelapi/read/GetSheetsByIndexTest.java
Author :	Sudhakar KV
Email :	[email protected]


package com.bethecoder.tutorials.jexcelapi.read;



import java.io.File;

import java.io.IOException;



import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;



public class GetSheetsByIndexTest {



  /**

   * @param args

   * @throws IOException 

   * @throws BiffException 

   */

  public static void main(String[] args) throws BiffException, IOException {

    //Read the given XL sheet 

    Workbook workbook = Workbook.getWorkbook(new File("C:/JXL/Sheet-Names.xls"));

    System.out.println("Number of sheets in this workbook : " + workbook.getNumberOfSheets());

    

    Sheet sheet = null;

    

    for (int i = 0 ; i < workbook.getNumberOfSheets() ; i ++ ) {

      sheet = workbook.getSheet(i);

      System.out.println("Sheet Name[" + i + "] = " + sheet.getName());

    }

    

    //Close and free allocated memory 

    workbook.close(); 

  }



}