2 Replies Latest reply on Jan 14, 2010 7:37 PM by ivanviragine

    Seam Excel exporter column styling does not apply.

    anup
      I have two isssues while using excelExporter from a .xhtml page.

      Problem 1: I cannot use the column level styling, I want to hide one column while exporting to excel. Below code is not working for me.

      <h:commandButton id="exportToExcel" value="Export to Excel"
                                  action="#{org.jboss.seam.excel.exporter.excelExporter.export('mainForm:userProfileTable')}"/>

      <rich:column id="checkCol" sortable="false" width="10"
            rendered="#{userProfile.hasEditPermission}" style="xls-column-hidden:true" >

      </rich:column>

      Problem 2: Is there anyway to hide a cell to be exported to excel. I have a following scenario.

      <h:commandButton id="exportToExcel" value="Export to Excel"
                                  action="#{org.jboss.seam.excel.exporter.excelExporter.export('mainForm:userProfileTable')}"/>


      <rich:column id="amountCol" width="200"
                              style="text-align: right;">

      <h:outputText id="amountField" value="#dataHolder.amount}">
      <h:outputText id="currencyField" value="#currencyBean.localCurrency}" />

      </rich:column>

      I want to hide currencyField while transporting to the excel. Any idea is there anything i am missing or richfaces do not have this feature.