Multiple List on Excel worrksheet

[yulrizka]

I have a problem here.

I already have two list, lest just say that the coaHome.coaOrderByNoPerkiraan;
to display it on excel this works

<e:workbook
   xmlns:e="http://jboss.com/products/seam/excel"
   xmlns:f="http://java.sun.com/jsf/core"
   xmlns:ui="http://java.sun.com/jsf/facelets"
   >        
          <e:link URL="/stylesheet/excel.css"/>
      <e:worksheet name="WS" styleClass="background-white" value="#{coaHome.coaOrderByNoPerkiraan}" var ="_coa"
           startRow="9">
     
               <e:column style="xls-column-width: 3320">
               <e:cell value="#{_coa.noPerkiraan}"/>
          </e:column>                   
          <e:column style="xls-column-width: 12420" >
               <e:cell value="#{_coa.namaPerkiraan}"/>
          </e:column>     
          
          
     </e:worksheet>
</e:workbook>

but how to display another list on the worksheet.

and also this is doesn't work

<e:workbook
   xmlns:e="http://jboss.com/products/seam/excel"
   xmlns:f="http://java.sun.com/jsf/core"
   xmlns:ui="http://java.sun.com/jsf/facelets"
   >        
          <e:link URL="/stylesheet/excel.css"/>
      <e:worksheet name="WS" styleClass="background-white" 
           startRow="9">
     
               <e:column style="xls-column-width: 3320" value="#{coaHome.coaOrderByNoPerkiraan}" var ="_coa">
               <e:cell value="#{_coa.noPerkiraan}"/>
          </e:column>                                       
     </e:worksheet>
</e:workbook>

thank youfor your help

[nickarls]

1. Add several worksheets with same name and they will merge. Use different startRow/startColumn for placing


2. Doesn't work in what way == what are you trying to do?

[yulrizka]

Thank you Nicklas for your respond

Your first suggestion is what i really wanted to do. i thought that wasn't the best way to do it.

thank you very much