3 Replies Latest reply on Aug 12, 2010 7:00 AM by cash1981

    Seam excel support CSV format problems

      Here's the example code

      "<e:workbook
              xmlns:e="http://jboss.com/products/seam/excel"
              xmlns:f="http://java.sun.com/jsf/core"
              filename="productsExport"
              encoding = "UTF8"
              namesDisabled="true"
              type="csv"
              >
              <e:worksheet value="#{productList}" var="p" name="List Of All Products" >
                      <e:column>
                              <f:facet name="header">
                                      <e:cell value="Product Name"/>
                              </f:facet>
                              <e:cell value="#{p.ProductName}"/>
                      </e:column>              
              </e:worksheet>
      </e:workbook>
      "
      Basically,
      problem 1: if you set type="jxl", everything works fine. But if you set type="csv", the output will miss the last row.
      problem 2: the filename attribute never works.
      problem 3: when you set type= "csv", I don't know how to prevent the name of the worksheet get exported. If you don't define a name in the worksheet, It is going to appear as "null" on the first line of the CSV generated. set namesDisabled="true" in workbook did nothing.