public ExportRow addRow(final Object... values) { final ExportRow row = addRow(); row.setValues(values); return row; }
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)); } }
@Override public void onClick() { checkAdminUser(); final List<DatabaseUpdateDO> updateEntries = myDatabaseUpdater.getUpdateHistory(); final ExportWorkbook workbook = new ExportWorkbook(); final ExportSheet sheet = workbook.addSheet("Update history"); sheet.getContentProvider().setColWidths(new int[] { 20, 10, 20, 15, 50, 20 }); sheet.getContentProvider().putFormat(java.sql.Timestamp.class, "YYYY-MM-DD hh:mm:ss"); sheet.setPropertyNames( new String[] { "regionId", "versionString", "updateDate", "executedBy.username", "description", "executionResult" }); sheet.addRow().setValues("region id", "version", "update date", "executed by", "description", "execution result"); sheet.addRows(updateEntries); final String filename = "ProjectForge-UpdateHistory_" + DateHelper.getDateAsFilenameSuffix(new Date()) + ".xls"; final byte[] xls = workbook.getAsByteArray(); DownloadUtils.setDownloadTarget(xls, filename); }
final ExportSheet sheet = workbook.addSheet("Test"); sheet.getContentProvider().setColWidths(20, 20, 20); sheet.addRow().setValues("Type", "Precision", "result"); sheet.addRow().setValues("Java output", ".", "Tue Sep 28 00:27:10 UTC 2010"); sheet.addRow().setValues("DateHolder", "DAY", getDateHolder().setPrecision(DatePrecision.DAY)); sheet.addRow().setValues("DateHolder", "HOUR_OF_DAY", getDateHolder().setPrecision(DatePrecision.HOUR_OF_DAY)); sheet.addRow().setValues("DateHolder", "MINUTE_15", getDateHolder().setPrecision(DatePrecision.MINUTE_15)); sheet.addRow().setValues("DateHolder", "MINUTE", getDateHolder().setPrecision(DatePrecision.MINUTE)); sheet.addRow().setValues("DateHolder", "SECOND", getDateHolder().setPrecision(DatePrecision.SECOND)); sheet.addRow().setValues("DateHolder", "MILLISECOND", getDateHolder().setPrecision(DatePrecision.MILLISECOND)); sheet.addRow().setValues("DateHolder", "-", getDateHolder()); sheet.addRow().setValues("DayHolder", "-", new DayHolder(getDate())); sheet.addRow().setValues("java.util.Date", "-", getDate()); sheet.addRow().setValues("java.sql.Timestamp", "-", new Timestamp(getDate().getTime())); sheet.addRow().setValues("int", "-", 1234); sheet.addRow().setValues("BigDecimal", "-", new BigDecimal("123123123.123123123123")); final File file = WorkFileHelper.getWorkFile(filename); log.info("Writing Excel test sheet to work directory: " + file.getAbsolutePath());