109
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
Output:
See at bottom of the file, two sheets are created First Sheet, Second Sheet.
Next TopicApache POI Excel Cell