Databases
StackOverflow2013
Postsdbo
POPrimeFaces DataExporter to XLS for multiple Columns not working correctly
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPrimeFaces DataExporter to XLS for multiple Columns not working correctly
    text
    copied!<p>I have a <code>&lt;p:dataTable&gt;</code>:</p> <pre class="lang-html prettyprint-override"><code>&lt;p:dataTable id="contracttblenone" var="contract" value="#{reportController.listcontract}" rowKey="#{contract.id}" paginator="true" rows="10" paginatorPosition="bottom" paginatorTemplate="{CurrentPageReport} {FirstPageLink} {PreviousPageLink} {PageLinks} {NextPageLink} {LastPageLink} {RowsPerPageDropdown}" rowsPerPageTemplate="5,10,15" resizableColumns="true" emptyMessage=""&gt; &lt;p:column&gt; &lt;f:facet name="header"&gt; &lt;h:outputText value="№"/&gt; &lt;/f:facet&gt; &lt;h:outputText value="#{contract.id}"/&gt; &lt;/p:column&gt; &lt;p:column&gt; &lt;f:facet name="header"&gt; &lt;h:outputText value="Firma Ad?"/&gt; &lt;/f:facet&gt; &lt;h:outputText value="#{contract.name}"/&gt; &lt;/p:column&gt; &lt;p:columns width="60" value="#{contract.liscolumn}" var="column"&gt; &lt;f:facet name="header"&gt; &lt;h:outputText value=" #{column.header} "/&gt; &lt;/f:facet&gt; &lt;h:outputText value=" #{column.property} " /&gt; &lt;/p:columns&gt; &lt;f:facet name="header"&gt; &lt;h:outputText value="Sirket Sozlesmeler"/&gt; &lt;/f:facet&gt; &lt;/p:dataTable&gt; </code></pre> <p>And this is my commandLink:</p> <pre class="lang-html prettyprint-override"><code> &lt;h:commandLink&gt; &lt;p:graphicImage value="../img/xls.png" /&gt; &lt;p:dataExporter type="xls" target=":formreport:contracttblenone" fileName="report" /&gt; &lt;/h:commandLink&gt; </code></pre> <p>Here is how the dataTable looks</p> <p><img src="https://i.stack.imgur.com/d8BkQ.jpg" alt="enter image description here"></p> <p>But exported xls is different. It is modifying all rowas as last one here is the snaphsot from excel:</p> <p><img src="https://i.stack.imgur.com/srPve.jpg" alt="x"></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload