public static void main(String... args) throws IOException { final ExportWorkbook workbook = new ExportWorkbook(); ExportSheet sheet = workbook.addSheet("Data types"); sheet.getContentProvider().setColWidths(20, 20); sheet.addRow().setValues("Type", "result"); sheet.addRow().setValues("String", "This is a text."); sheet.addRow().setValues("int", 1234); sheet.addRow().setValues("BigDecimal", new BigDecimal("1042.3873")); Date date = new Date(); sheet.addRow().setValues("Date", date); sheet.addRow().setValues("SQL-Date", new java.sql.Date(date.getTime())); sheet.addRow().setValues("Timestamp", new Timestamp(date.getTime())); sheet = workbook.addSheet("Own data types"); sheet.getContentProvider().setColWidths(20, 20).putFormat(Currency.class, "#,##0.00;[Red]-#,##0.00"); sheet.addRow().setValues("Type", "result"); sheet.addRow().setValues("Currency", new Currency("1023.873").getValue()); sheet.addRow().setValues("Currency", new Currency("-10").getValue()); final File file = new File("target/test-excel.xls"); log.info("Writing Excel test sheet to work directory: " + file.getAbsolutePath()); workbook.write(new FileOutputStream(file)); } }