使用primefaces将datatree表格导出为Excel表

前端页面

<h:form>
<p:dataTable var="assignmentExcelDto"
				value="#{assignmentExcelView.assignmentExcelDto}" id="tableId">
 //下面内容省略

          <p:panel header="Export All Data">
               <p:commandButton value="Export as Excel" ajax="false">
					<p:dataExporter type="xls" target="tableId" fileName="myexcel"
						postProcessor="#{assignmentExcelView.postProcessXLS}" />
				</p:commandButton>
             </p:panel>

依赖

      <dependencyManagement>
                                <dependency>
				<groupId>org.jboss.bom</groupId>
				<artifactId>jboss-javaee-6.0-with-tools</artifactId>
				<version>${version.jboss.bom}</version>
				<type>pom</type>
				<scope>import</scope>
			</dependency>
		</dependencies>
	</dependencyManagement>

<dependencies>
	<!--导出Excel -->
		<dependency>
            <groupId>com.lowagie</groupId>
            <artifactId>itext</artifactId>
            <version>2.1.7</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>
        </dependencies>

逻辑代码（@Named管理的类）

 public void postProcessXLS(Object document) {
	        HSSFWorkbook wb = (HSSFWorkbook) document;
	        HSSFSheet sheet = wb.getSheetAt(0);
	        CellStyle style = wb.createCellStyle();
	        style.setFillBackgroundColor(IndexedColors.AQUA.getIndex());
	 
	        for (Row row : sheet) {
	            for (Cell cell : row) {
	                cell.setCellValue(cell.getStringCellValue().toUpperCase());
	                cell.setCellStyle(style);
	            }
	        }
	    }