Workbook Functions

These functions are used to manipulate Microsoft Excel Workbooks. This set of functions use the XSSFWorkbook class object. Please refer to the documentation for this class for its properties and methods.

• workbook.create()
• workbook.open(String filename)
• workbook.convertToBase64(Workbook wb)
• workbook.convertFromBase64(String base64)
• workbook.workbookFromQuery(String datasourceName, String sql)
• workbook.getColumnName(int columnNumber)