POI org.apache.poi.hssf.usermodel HSSFWorkbook getSheetAt(int index)

POI org.apache.poi.hssf.usermodel HSSFWorkbook getSheetAt(int index)

Description Of HSSFWorkbook: getSheetAt(int index)

The java.lang.HSSFWorkbook.getSheetAt(int index) get the HSSFSheet object at the given index

HSSFWorkbook.getNumberOfSheets() method returns HSSFSheet

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");
  
  HSSFSheet sheet = workbook.getSheetAt(0);
  System.out.println("sheet 0 name : " + sheet.getSheetName());
  
  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();
    }
   }
  }
 }
}