Home » Apache POI Excel Workbook

Apache POI Excel Workbook

by Online Tutorials Library

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


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

Apache POI Workbook Sheet

You may also like