Amigos,
estou querendo exportar um arquivo para excel usando PrimeFaces porém quando exporta gerar apenas as informações da lista do meu DataTable e não esta gerando as informações da lista do meu SubTable
Alguém pode ajudar ?
<f:subview id="subviewIdDataTable42" rendered="#{not empty relatPaywareContabilMBean.retornoColecaoDados}">
<p:dataTable id="idDataTable42" var="relatorio42" value="#{relatPaywareContabilMBean.retornoColecaoDados}" paginator="false" scrollable="true" scrollHeight="450" emptyMessage="Registro nao encontrado" >
<p:columnGroup type="header" >
<p:row>
<p:column rowspan="2" headerText="Relatorio" />
<p:column colspan="2" headerText="Valores Payware" />
<p:column colspan="2" headerText="Valores Contábil" />
<p:column colspan="2" headerText="Valores Diferenças" />
</p:row>
<p:row>
<p:column headerText="Debito" style="width:220px" />
<p:column headerText="Credito" style="width:220px" />
<p:column headerText="Debito" style="width:220px"/>
<p:column headerText="Credito" style="width:220px" />
<p:column headerText="Debito" style="width:220px"/>
<p:column headerText="Credito" style="width:220px" />
</p:row>
</p:columnGroup>
<p:subTable id="idSubTable" var="dados" value="#{relatorio42.dados}" >
<f:facet name="header" >
<h:outputText value="Conta: #{relatorio42.codConta} - #{relatorio42.descConta}" styleClass="labelTituloConta" />
</f:facet>
<p:column style="text-align: left; width:30%; ">
<f:facet name="header"> <h:outputText value="Descricao" /> </f:facet>
<h:outputText value="#{dados.codRelPay}" styleClass="labelTituloConta" />
<br/>
<h:outputText value="#{dados.descItemRel}" style="font-size: 10px;" title="#{dados.descItemRel}"/>
</p:column>
<p:column style="text-align: right; width: 5%; background-color:#DDDDDD" >
<f:facet name="header"> <h:outputText value="Valor Debito Payware" /> </f:facet>
<h:outputText value="#{dados.vlrDebitoRel != null ? dados.vlrDebitoRel : '0,00'}" >
<f:convertNumber minFractionDigits="2" type="number" locale="pt_BR"/>
</h:outputText>
</p:column>
<p:column style="text-align: right; width: 5%;" >
<f:facet name="header"> <h:outputText value="Valor Credito Payware" /> </f:facet>
<h:outputText value="#{dados.vlrCreditoRel != null ? dados.vlrCreditoRel : '0,00'}" >
<f:convertNumber minFractionDigits="2" type="number" locale="pt_BR" />
</h:outputText>
</p:column>
<p:column style="text-align: right; width: 5%; background-color:#DDDDDD" >
<f:facet name="header"> <h:outputText value="Valor Debito Contabil" /> </f:facet>
<h:outputText value="#{dados.vlrDebitoContab != null ? dados.vlrDebitoContab : '0,00'}" >
<f:convertNumber minFractionDigits="2" type="number" locale="pt_BR" />
</h:outputText>
</p:column>
<p:column style="text-align: right; width: 5%; " >
<f:facet name="header"> <h:outputText value="Valor Credito Contabil" /> </f:facet>
<h:outputText value="#{dados.vlrCreditoContab != null ? dados.vlrCreditoContab : '0,00'}" >
<f:convertNumber minFractionDigits="2" type="number" locale="pt_BR" />
</h:outputText>
</p:column>
<p:column style="text-align: right; width: 5%; background-color:#DDDDDD" >
<f:facet name="header"> <h:outputText value="Valor Diferença Debito" /> </f:facet>
<h:outputText value="#{dados.vlrDifDebito != null ? dados.vlrDifDebito : '0,00'}" >
<f:convertNumber minFractionDigits="2" type="number" locale="pt_BR" />
</h:outputText>
</p:column>
<p:column style="text-align: right; width: 5%; " >
<f:facet name="header"> <h:outputText value="Valor Diferença Credito" /></f:facet>
<h:outputText value="#{dados.vlrDifCredito != null ? dados.vlrDifCredito : '0,00'}" >
<f:convertNumber minFractionDigits="2" type="number" locale="pt_BR" />
</h:outputText>
</p:column>
<p:columnGroup type="footer">
<p:row>
<p:column colspan="1" footerText="Total por Conta:" style="text-align:left" />
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatorio42.totalDebitoPayware)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatorio42.totalCreditoPayware)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatorio42.totalDebitoContabil)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatorio42.totalCreditoContabil)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatorio42.totalDiferencaDebito)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatorio42.totalDiferencaCredito)}" style="text-align: right !important;"/>
</p:row>
</p:columnGroup>
</p:subTable>
<p:columnGroup type="footer">
<p:row>
<p:column colspan="1" footerText="Total Geral:" style="text-align:left" />
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatPaywareContabilMBean.totalDebitoPayware)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatPaywareContabilMBean.totalCreditoPayware)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatPaywareContabilMBean.totalDebitoContabil)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatPaywareContabilMBean.totalCreditoContabil)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatPaywareContabilMBean.totalDiferencaDebito)}" style="text-align: right !important;"/>
<p:column footerText="#{relatPaywareContabilDelegate.getDecimalFormat('###,###.00', relatPaywareContabilMBean.totalDiferencaCredito)}" style="text-align: right !important;"/>
</p:row>
</p:columnGroup>
</p:dataTable>
<p:commandLink id="pdf" ajax="false" >
<p:graphicImage value="/resources/imagens/pdf.png"/>
<pe:exporter type="pdf" target="idDataTable42" fileName="Relatorio" isSubTable="true"/>
</p:commandLink>
<p:spacer width="20"/>
<p:commandLink id="xlsx" ajax="false" >
<p:graphicImage value="/resources/imagens/excel.png"/>
<pe:exporter type="xlsx" target="idDataTable42" fileName="Relatorio" isSubTable="true"/>
</p:commandLink>
</f:subview>