1 Reply Latest reply on Feb 15, 2011 8:59 AM by carsi

    Excel - columns visible

      Hi,


      I would like to export a dataTable with rich:dataTable (again) which can has not visible columns.


      Look as the following code:



      <rich:dataTable id="tableTemp"
              value="#{affichageComposant.listHistoTempEfficaceDTO}" var="model">
      <rich:column>
              <f:facet name="header">
                      <h:outputText value="température de réference" />
              </f:facet>
              <h:outputText value="#{model.tempRef}" />
      </rich:column>
      <rich:columns value="#{affichageComposant.getAllColumnsDTO()}"
              var="columns" index="ind1" visible="#{columns.isVisible}">
              <f:facet name="header" style="xls-column-export:true">
                      <h:outputText value="#{columns.stationName}" />
              </f:facet>
              <h:outputText value="#{model.allTemperature[ind1]}" />
      </rich:columns>
      </rich:dataTable>
      





      In Seam 2.1.1.GA, when I execute the exportation, I have all of data columns even if I have declared columns visibility on false.


      But in seam 2.2.0.GA, the columns invisibility was not exporting in excel..


      Should i add an attribute to forced columns invisible to be exported?


      Michel.