public void putCurrencyFormat(final ContentProvider sheetProvider, final ExportColumn exportColumn) { sheetProvider.putFormat(exportColumn, "#,##0.00;[Red]-#,##0.00"); exportColumn.setWidth(12); } }
/** * @see org.projectforge.export.MyExcelExporter#putFieldFormat(ContentProvider, * java.lang.reflect.Field, org.projectforge.common.anots.PropertyInfo, ExportColumn) */ @Override public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo, final ExportColumn exportColumn) { if ("month".equals(field.getName()) == true) { sheetProvider.putFormat(exportColumn, "mmm"); exportColumn.setWidth(6); } else if ("year".equals(field.getName()) == true) { sheetProvider.putFormat(exportColumn, "#"); exportColumn.setWidth(6); } else { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn); } }
putCurrencyFormat(sheetProvider, exportColumn); } else if (type == PropertyType.DATE) { sheetProvider.putFormat(exportColumn, "MM/dd/yyyy"); } else if (type == PropertyType.DATE_TIME) { sheetProvider.putFormat(exportColumn, "MM/dd/yyyy HH:mm"); } else if (type == PropertyType.DATE_TIME_SECONDS) { sheetProvider.putFormat(exportColumn, "MM/dd/yyyy HH:mm:ss"); } else if (type == PropertyType.DATE_TIME_MILLIS) { sheetProvider.putFormat(exportColumn, "MM/dd/yyyy HH:mm:ss.fff"); } else if (type == PropertyType.UNSPECIFIED) { if (java.sql.Date.class.isAssignableFrom(field.getType()) == true) { sheetProvider.putFormat(exportColumn, "MM/dd/yyyy"); } else if (java.util.Date.class.isAssignableFrom(field.getType()) == true) { sheetProvider.putFormat(exportColumn, "MM/dd/yyyy HH:mm"); } else if (java.lang.Integer.class.isAssignableFrom(field.getType()) == true) { exportColumn.setWidth(10);
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE)); exportColumn.setWidth(10); } else if (type == PropertyType.DATE_TIME) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MINUTES)); exportColumn.setWidth(10); } else if (type == PropertyType.DATE_TIME_SECONDS) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_SECONDS)); exportColumn.setWidth(16); } else if (type == PropertyType.DATE_TIME_MILLIS) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MILLIS)); exportColumn.setWidth(18); } else if (type == PropertyType.UNSPECIFIED) { if (java.sql.Date.class.isAssignableFrom(field.getType()) == true) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE)); exportColumn.setWidth(10); } else if (java.util.Date.class.isAssignableFrom(field.getType()) == true) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MINUTES)); exportColumn.setWidth(16); } else {
sheetProvider.putFormat(Col.UNASSIGNEDHOURS, "0.00"); sheetProvider.putFormat(Col.MONDAYHOURS, "0.00"); sheetProvider.putFormat(Col.TUESDAYHOURS, "0.00"); sheetProvider.putFormat(Col.WEDNESDAYHOURS, "0.00"); sheetProvider.putFormat(Col.THURSDAYHOURS, "0.00"); sheetProvider.putFormat(Col.FRIDAYHOURS, "0.00"); sheetProvider.putFormat(Col.WEEKENDHOURS, "0.00");
sheetProvider.putFormat(MyXlsContentProvider.FORMAT_CURRENCY, PosCol.NETSUM, PosCol.INVOICED, PosCol.TO_BE_INVOICED); sheetProvider .putFormat(DateFormats.getExcelFormatString(DateFormatType.DATE), PosCol.DATE_OF_OFFER, PosCol.DATE_OF_ENTRY, PosCol.PERIOD_OF_PERFORMANCE_BEGIN, PosCol.PERIOD_OF_PERFORMANCE_END); Map<PosCol, BigDecimal> istSumMap = createIstSumMap();
@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); }
employeeSheet.setColumnWidth(6, 20 * 256); final ContentProvider provider = employeeSheet.getContentProvider(); provider.putFormat("STUNDEN", "0.00;[Red]-0.00"); final ExportRow employeeRow = employeeSheet.addRow(); employeeRow.addCell(0, ThreadLocalUserContext.getLocalizedString("fibu.employee")); sheetProvider.putFormat("STUNDEN", "0.00"); sheetProvider.putFormat("BRUTTO_MIT_AG", "#,##0.00;[Red]-#,##0.00"); sheetProvider.putFormat("KORREKTUR", "#,##0.00;[Red]-#,##0.00"); sheetProvider.putFormat("SUMME", "#,##0.00;[Red]-#,##0.00"); sheetProvider.putFormat("KOST1", "#"); sheetProvider.putFormat("KOST2", "#"); sheetProvider.putFormat("KONTO", "#"); sheetProvider.putFormat("GEGENKONTO", "#"); sheetProvider.putFormat("DATUM", "dd.MM.yyyy");
ExportSheet sheet = xls.addSheet(sheetTitle); ContentProvider sheetProvider = sheet.getContentProvider(); sheetProvider.putFormat(MyXlsContentProvider.FORMAT_CURRENCY, OrderCol.NETSUM, OrderCol.INVOICED, OrderCol.TO_BE_INVOICED); sheetProvider.putFormat(DateFormats.getExcelFormatString(DateFormatType.DATE), OrderCol.DATE_OF_ENTRY, OrderCol.DATE_OF_OFFER, OrderCol.ORDER_DATE); sheet.createFreezePane(1, 1); sheet.setColumns(columns); sheet = xls.addSheet(sheetTitle); sheetProvider = sheet.getContentProvider(); sheetProvider.putFormat(MyXlsContentProvider.FORMAT_CURRENCY, PosCol.NETSUM, PosCol.INVOICED, PosCol.TO_BE_INVOICED); sheetProvider.putFormat(DateFormats.getExcelFormatString(DateFormatType.DATE), PosCol.DATE_OF_OFFER, PosCol.DATE_OF_ENTRY, PosCol.PERIOD_OF_PERFORMANCE_BEGIN, PosCol.PERIOD_OF_PERFORMANCE_END); sheet = xls.addSheet(sheetTitle); sheetProvider = sheet.getContentProvider(); sheetProvider.putFormat(MyXlsContentProvider.FORMAT_CURRENCY, PaymentsCol.AMOUNT); sheet.createFreezePane(1, 1); sheet.setColumns(columns);
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)); } }
sheetProvider.putFormat(InvoicesCol.BRUTTO, "#,##0.00;[Red]-#,##0.00"); sheetProvider.putFormat(InvoicesCol.KORREKTUR, "#,##0.00;[Red]-#,##0.00"); sheetProvider.putFormat(InvoicesCol.KOST1, "#"); sheetProvider.putFormat(InvoicesCol.KOST2, "#"); sheetProvider.putFormat(InvoicesCol.DATE, "dd.MM.yyyy");
int colNo = 0; I18nExportColumn exportColumn = new I18nExportColumn("date", "date", 10); sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE)); cols[colNo++] = exportColumn;