POI org.apache.poi.hssf.usermodel HSSFWorkbook getSheetIndex(Sheet sheet)

POI org.apache.poi.hssf.usermodel HSSFWorkbook getSheetIndex(Sheet sheet)

Description Of HSSFWorkbook: getSheetIndex(Sheet sheet)

The java.lang.HSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

HSSFWorkbook.getSheetIndex(Sheet sheet) method returns int index of sheet

Code Example Java HSSFWorkbook

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class PoiExam {
 public static void main(String[] args) {
  HSSFWorkbook workbook = new HSSFWorkbook();
  HSSFSheet sheet1 = workbook.createSheet("sheetname 1");
  HSSFSheet sheet2 = workbook.createSheet("sheetname 2");
  
  int sheetindex1 = workbook.getSheetIndex(sheet1);
  int sheetindex2 = workbook.getSheetIndex(sheet2);
  System.out.println("sheet1 is index : " + sheetindex1);
  System.out.println("sheet1 is index : " + sheetindex2);
  
  FileOutputStream fos = null;
  try {
   fos = new FileOutputStream(new File("PoiExam.xls"));
   workbook.write(fos);
   System.out.println("SUCCESS");
  } catch (IOException e) {
   e.printStackTrace();
  } finally {
   if (fos != null) {
    try {
     fos.flush();
     fos.close();
    } catch (IOException e) {
     e.printStackTrace();
    }
   }
  }
 }
}