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);
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);
}
}