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

    Excel - columns visible

    Michel Thai Newbie


      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">
              <f:facet name="header">
                      <h:outputText value="température de réference" />
              <h:outputText value="#{model.tempRef}" />
      <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}" />
              <h:outputText value="#{model.allTemperature[ind1]}" />

      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?