Apache POI Excel Workbook

by Online Tutorials Library July 14, 2022

Apache POI Workbook Sheet

To create a sheet in excel, POI provides a method createSheet() which creates a new sheet each time when function is called. While creating sheet consider the following points.

Name must not exceed 31 characters.
must not contain any of the any of the following characters (0x0000, 0x0003, colon (:), backslash (), asterisk (*), question mark (?), forward slash (/), opening square bracket ([), closing square bracket (])).

Lets see an example in which we are using createSheet() method to create two independent sheets.

Apache POI Workbook Sheet Example

  package poiexample;  import java.io.FileNotFoundException;  import java.io.FileOutputStream;  import java.io.IOException;  import java.io.OutputStream;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  public class NewSheet {  public static void main(String[] args) throws FileNotFoundException, IOException {  Workbook wb = new HSSFWorkbook();      try  (OutputStream fileOut = new FileOutputStream(“tutoraspire.xls”)) {          Sheet sheet1 = wb.createSheet(“First Sheet”);          Sheet sheet2 = wb.createSheet(“Second Sheet”);          wb.write(fileOut);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

See at bottom of the file, two sheets are created First Sheet, Second Sheet.

Apache POI Workbook Sheet

Next TopicApache POI Excel Cell

Apache POI Excel Workbook

Apache POI Workbook Sheet

Apache POI Workbook Sheet Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like