public void addRows(final Collection<?> rowBeans, final int startCol) { for (final Object rowBean : rowBeans) { addRow(rowBean, startCol); } }
@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); }
public void addRows(final Object[] rowBeans, final int startCol) { for (final Object rowBean : rowBeans) { addRow(rowBean, startCol); } }
public ExportRow addRow(final Object rowBean) { return addRow(rowBean, 0); }
public ExportRow addRow(final Object rowBean, final int startCol) { final ExportRow row = addRow(); row.fillBean(rowBean, propertyNames, 0); return row; }
public ExportRow addRow(final Object... values) { final ExportRow row = addRow(); row.setValues(values); return row; }
/** * Convenient method: Adds all column names, titles, width and adds a head row. * * @param columns */ public void setColumns(final List<ExportColumn> columns) { if (columns == null) { return; } // build all column names, title, widths from fixed and variable columns final String[] colNames = new String[columns.size()]; final ExportRow headRow = addRow(); int idx = 0; for (final ExportColumn col : columns) { addHeadRowCell(headRow, col, colNames, idx++); } setPropertyNames(colNames); }
/** * Convenient method: Adds all column names, titles, width and adds a head row. * * @param columns */ public void setColumns(final ExportColumn... columns) { if (columns == null) { return; } // build all column names, title, widths from fixed and variable columns final String[] colNames = new String[columns.length]; final ExportRow headRow = addRow(); int idx = 0; for (final ExportColumn col : columns) { addHeadRowCell(headRow, col, colNames, idx++); } setPropertyNames(colNames); }
sheet.addRow(mapping.getMapping(), 0);
private void addEmployeeRow(final ExportSheet sheet, final EmployeeDO employee, final BigDecimal numberOfWorkingDays, final BigDecimal totalDuration, final MonthlyEmployeeReport report) { final PFUserDO user = getUserGroupCache().getUser(employee.getUserId()); final ExportRow row = sheet.addRow(); row.addCell(0, user.getFullname()); // Wochenstunden row.addCell(1, employee.getWeeklyWorkingHours(), "STUNDEN"); // Sollstunden: Wochenstunden * Arbeitstage / 5 Arbeitstage pro Woche BigDecimal wochenstunden = employee.getWeeklyWorkingHours(); if (wochenstunden == null) { wochenstunden = BigDecimal.ZERO; } final BigDecimal soll = wochenstunden.multiply(numberOfWorkingDays).divide(new BigDecimal(5), 2, RoundingMode.HALF_UP); row.addCell(2, soll, "STUNDEN"); // Iststunden final BigDecimal total = totalDuration.divide(new BigDecimal(3600000), 2, RoundingMode.HALF_UP); row.addCell(3, total, "STUNDEN"); // Differenz final BigDecimal differenz = total.subtract(soll); row.addCell(4, differenz, "STUNDEN"); row.addCell(5, report.getUnbookedDays().size()); row.addCell(6, report.getFormattedUnbookedDays()); }
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)); } }
PropertyMapping mapping = new PropertyMapping(); addPosMapping(mapping, order, pos, startDate); sheet.addRow(mapping.getMapping(), 0);
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());
sheet.addRow(); // Column headers sheet.setMergedRegion(0, 0, Col.MAILING_ADDRESS.ordinal(), Col.MAILING_STATE.ordinal(), "Mailing"); sheet.setMergedRegion(0, 0, Col.ADDRESS.ordinal(), Col.STATE.ordinal(), for (final AddressDO address : list) { addAddressMapping(mapping, address, params); sheet.addRow(mapping.getMapping(), 0);
protected void exportExcel() { log.info("Exporting kost1 list."); refresh(); final List<Kost1DO> kost1List = getList(); if (kost1List == null || kost1List.size() == 0) { // Nothing to export. form.addError("validation.error.nothingToExport"); return; } final String filename = "ProjectForge-Kost1Export_" + DateHelper.getDateAsFilenameSuffix(new Date()) + ".xls"; final ExportWorkbook xls = new ExportWorkbook(); final ContentProvider contentProvider = new MyXlsContentProvider(xls); xls.setContentProvider(contentProvider); final ExportSheet sheet = xls.addSheet(ThreadLocalUserContext.getLocalizedString("fibu.kost1.kost1s")); final ExportColumn[] cols = new ExportColumn[] { // new I18nExportColumn(Col.KOST, "fibu.kost1", MyXlsContentProvider.LENGTH_KOSTENTRAEGER), new I18nExportColumn(Col.DESCRIPTION, "description", MyXlsContentProvider.LENGTH_STD), new I18nExportColumn(Col.STATUS, "status", MyXlsContentProvider.LENGTH_STD) }; sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final Kost1DO kost : kost1List) { mapping.add(Col.KOST, kost.getFormattedNumber()); mapping.add(Col.STATUS, kost.getKostentraegerStatus()); mapping.add(Col.DESCRIPTION, kost.getDescription()); sheet.addRow(mapping.getMapping(), 0); } sheet.setZoom(3, 4); // 75% DownloadUtils.setDownloadTarget(xls.getAsByteArray(), filename); }
mapping.add(Col.DESCRIPTION, kost.getDescription()); mapping.add(Col.COMMENT, kost.getComment()); sheet.addRow(mapping.getMapping(), 0);
public void addCreditorInvoicesSheet(final MyExcelExporter exporter, final String title, final Collection<EingangsrechnungDO> list) { final ExportSheet sheet = exporter.addSheet(title); sheet.createFreezePane(0, 1); final ContentProvider sheetProvider = sheet.getContentProvider(); final ExportColumn[] cols = new ExportColumn[5]; int i = 0; cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "datum"); cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "faelligkeit"); cols[i] = new I18nExportColumn("gross", "fibu.rechnung.bruttoBetrag", 10); exporter.putCurrencyFormat(sheetProvider, cols[i++]); cols[i++] = new I18nExportColumn("creditor", "fibu.common.creditor", 60); cols[i++] = new I18nExportColumn("subject", PropUtils.getI18nKey(AbstractRechnungDO.class, "betreff"), 100); // column property names sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final EingangsrechnungDO entry : list) { entry.recalculate(); mapping.add("datum", entry.getDatum()); mapping.add("faelligkeit", entry.getFaelligkeit()); mapping.add("gross", entry.getGrossSum()); mapping.add("creditor", entry.getKreditor()); mapping.add("subject", entry.getBetreff()); sheet.addRow(mapping.getMapping(), 0); } }
public void addDebitorInvoicesSheet(final MyExcelExporter exporter, final String title, final Collection<RechnungDO> list) { final ExportSheet sheet = exporter.addSheet(title); sheet.createFreezePane(0, 1); final ContentProvider sheetProvider = sheet.getContentProvider(); final ExportColumn[] cols = new ExportColumn[6]; int i = 0; cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "datum"); cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "faelligkeit"); cols[i] = new I18nExportColumn("gross", "fibu.rechnung.bruttoBetrag", 10); exporter.putCurrencyFormat(sheetProvider, cols[i++]); cols[i++] = new I18nExportColumn("number", "fibu.rechnung.nummer", 6); cols[i++] = new I18nExportColumn("debitor", "fibu.common.debitor", 60); cols[i++] = new I18nExportColumn("subject", PropUtils.getI18nKey(AbstractRechnungDO.class, "betreff"), 100); // column property names sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final RechnungDO entry : list) { entry.recalculate(); mapping.add("datum", entry.getDatum()); mapping.add("faelligkeit", entry.getFaelligkeit()); mapping.add("gross", entry.getGrossSum()); mapping.add("number", entry.getNummer()); mapping.add("debitor", entry.getKundeAsString()); mapping.add("subject", entry.getBetreff()); sheet.addRow(mapping.getMapping(), 0); } }
sheet.addRow(mapping.getMapping(), 0);
sheet.addRow(mapping.getMapping(), 0);