Java java.lang Boolean valueOf(String s)

Java java.lang Boolean valueOf(String s)

Description Of Boolean: valueOf(String s)

The java.lang.Boolean.valueOf(String s) returns a Boolean with a value represented by the specified string. The Boolean returned represents a true value if the string argument is not null and is equal, ignoring case, to the string "true".

Boolean.valueOf(String s) method returns the Boolean value represented by the string.

Code Example Java Boolean

public class BooleanExam {
 public static void main(String[] args) {
  String s1 = null;
  String s2 = "false";

  Boolean b1 = Boolean.valueOf(s1);
  Boolean b2 = Boolean.valueOf(s2);

  // print b1, b2 values
  System.out.println(b1);
  System.out.println(b2);
 }
}

POI org.apache.poi.hssf.usermodel HSSFWorkbook createSheet()

POI org.apache.poi.hssf.usermodel HSSFWorkbook createSheet()

Description Of HSSFWorkbook: createSheet()

The java.lang.HSSFWorkbook.createSheet() create Sheet of HSSFWorkbook

HSSFWorkbook.createSheet() method returns HSSFSheet

Code Example Java HSSFWorkbook

package exam.poi;

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();
  HSSFSheet sheet2 = workbook.createSheet();
  
  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();
    }
   }
  }
 }
}

POI org.apache.poi.hssf.usermodel HSSFWorkbook createSheet(java.lang.String sheetname)

POI org.apache.poi.hssf.usermodel HSSFWorkbook createSheet(java.lang.String sheetname)

Description Of HSSFWorkbook: createSheet(java.lang.String sheetname)

The java.lang.HSSFWorkbook.createSheet(java.lang.String sheetname) create Sheet of HSSFWorkbook and contain sheet name

HSSFWorkbook.createSheet(java.lang.String sheetname) method returns HSSFSheet

Code Example Java HSSFWorkbook

package exam.poi;

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");
  
  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();
    }
   }
  }
 }
}

POI org.apache.poi.hssf.usermodel HSSFWorkbook getNumberOfSheets()

POI org.apache.poi.hssf.usermodel HSSFWorkbook getNumberOfSheets()

Description Of HSSFWorkbook: getNumberOfSheets()

The java.lang.HSSFWorkbook.getNumberOfSheets() get the number of spreadsheets in the workbook (this will be three after serialization)

HSSFWorkbook.getNumberOfSheets() method returns number 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");
  
  System.out.println("number of Sheet : " + workbook.getNumberOfSheets());
  
  FileOutputStream fos = null;
  try {
   fos = new FileOutputStream(new File("PoiExam.xls"));
   workbook.write(fos);
   System.out.println("SUCCESS" + workbook.getNumberOfSheets());
  } catch (IOException e) {
   e.printStackTrace();
  } finally {
   if (fos != null) {
    try {
     fos.flush();
     fos.close();
    } catch (IOException e) {
     e.printStackTrace();
    }
   }
  }
 }
}

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();
    }
   }
  }
 }
}

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();
    }
   }
  }
 }
}

POI org.apache.poi.hssf.usermodel HSSFWorkbook getSheetIndex(java.lang.String name)

POI org.apache.poi.hssf.usermodel HSSFWorkbook getSheetIndex(java.lang.String name)

Description Of HSSFWorkbook: getSheetIndex(java.lang.String name)

The java.lang.HSSFWorkbook.getSheetIndex(java.lang.String name) Returns the index of the sheet by his name

HSSFWorkbook.getSheetIndex(java.lang.String name) method returns number of sheet by name, method return -1 is not found

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("sheetname 1");
  int sheetindex2 = workbook.getSheetIndex("sheetname 3");
  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();
    }
   }
  }
 }
}