public ExportSheet addSheet(final String sheetTitle) { final ContentProvider contentProvider = new MyXlsContentProvider(getWorkbook()) { /** * @see org.projectforge.export.MyXlsContentProvider#getCustomizedCellFormat(CellFormat, java.lang.Object) */ @Override protected CellFormat getCustomizedCellFormat(final CellFormat format, final Object value) { return null; } }; return addSheet(contentProvider, sheetTitle); }
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); } }
public void addAsExcelSheet(final MyExcelExporter exporter, final String sheetTitle) final ExportSheet sheet = exporter.addSheet(sheetTitle); sheet.createFreezePane(0, 1); final ContentProvider sheetProvider = sheet.getContentProvider();