Add header p:dataExporter type excel primefaces

Posted: October 15, 2012 in web

xhtml:

<p:dataExporter postProcessor=”#{reports.postProcessXLS}” type=”xls” target=”datatable”/>

Bean:

 public void postProcessXLS(Object document) {

HSSFWorkbook wb = (HSSFWorkbook) document;
 HSSFSheet sheet = wb.getSheetAt(0);
 sheet.shiftRows(0, sheet.getLastRowNum(), 1);
 HSSFCell cell = sheet.createRow(0).createCell(0);
 cell.setCellValue("Header Value");

HSSFFont font = wb.createFont();
 font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

HSSFCellStyle style = wb.createCellStyle();
 style.setFont(font);

cell.setCellStyle(style);
 sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, sheet.getRow(1).getLastCellNum() - 1));
 }
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s