DataTable
http://s15.postimg.org/7xp709vu3/exportdata.png
Excel Result
http://s29.postimg.org/7g52btf87/excel.png
Code: Select all
<p:commandLink id="xls" ajax="false">
<p:graphicImage library="default" name="images/arrow-back-icon-32.png" title="Voltar"/>
<pe:exporter type="xlsx" target=":frmTable:grid" fileName="#{reportViewBean.currentTable.tituloTabela}"/>
</p:commandLink>
Code: Select all
<p:dataTable id="grid"
sortMode="multiple"
paginator="true"
rows="10"
value="#{reportViewBean.rows}"
var="r"
filteredValue="#{reportViewBean.filtered}"
draggableColumns="true"
emptyMessage="Nenhum registro encontrado."
selection="#{reportViewBean.selectedRows}"
rowKey="#{r.rowkey}"
rowsPerPageTemplate="10,25,50,100,200,#{fn:length(reportViewBean.rows)}"
binding="#{reportViewBean.dataTable}"
scrollable="true"
widgetVar="reportTable"
>
<f:facet name="header">
#{reportViewBean.currentTable.tituloTabela}
</f:facet>
<p:column selectionMode="multiple" width="30">
</p:column>
<p:columns value="#{reportViewBean.currentTable.colunas}"
var="c"
columnIndexVar="i"
sortBy="#{r.cells[i].descricaoCelula}"
filterBy="#{r.cells[i].descricaoCelula}"
sortFunction="#{reportViewBean.customSortF}"
filterMatchMode="#{reportViewBean.columnFilters[i]}"
id="th"
width="200"
filterStyleClass="my-filter#{i} filter">
<f:facet name="header">
<div style="float: right; vertical-align: top">
<p:commandLink actionListener="#{reportViewBean.columnClickedListener(i)}" oncomplete="PF('dlg').show();" update=":frmTable:dlg" >
<h:graphicImage class="filter" library="default" name="images/filter-icon.png"/>
</p:commandLink>
</div>
#{c.descricaoColuna}
</f:facet>
<h:panelGroup class="#{reportViewBean.getColumnClass(r.cells[i])}" layout="block">
<h:outputLink value="#{r.cells[i].descricaoCelula}" rendered="#{reportViewBean.isLink(r.cells[i].descricaoCelula)}">
#{r.cells[i].descricaoCelula}
</h:outputLink>
<h:outputLabel value="#{r.cells[i].descricaoCelula}" rendered="#{not reportViewBean.isLink(r.cells[i].descricaoCelula)}"/>
</h:panelGroup>
</p:columns>
</p:dataTable>