protected void exportExcel()
{
log.info("Exporting kost1 list.");
refresh();
final List<Kost1DO> kost1List = getList();
if (kost1List == null || kost1List.size() == 0) {
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);
DownloadUtils.setDownloadTarget(xls.getAsByteArray(), filename);
}