- createWorkbook
Creates a writable workbook. When the workbook is closed, it will be streamed
directly to the output
- getWorkbook
A factory method which takes in an excel file and reads in the contents.
- getSheet
Gets the sheet with the specified name from within this workbook. As described
in the accompanying t
- getSheets
Gets the sheets within this workbook. Use of this method for large worksheets
can cause performance
- close
Closes this workbook, and frees makes any memory allocated available for garbage
collection
- getNumberOfSheets
Returns the number of sheets in this workbook
- findByName
Gets the named range from this workbook. The Range object returns contains all
the cells from the to
- findCellByName
Gets the named cell from this workbook. If the name refers to a range of cells,
then the cell on the
- getVersion
Accessor for the software version
- isProtected
Determines whether the sheet is protected
- parse
Parses the excel file. If the workbook is password protected a PasswordException
is thrown in case c