Excel - Dynamic columns

[mthai]

Hi,

I would like to export on excel a table with dynamics columns.
I was tried to use ui:repeat on e:workbook but doesn't work and i'm looking for un taglib like rich:columns but not exist..



`<e:worksheet value="#{listPerson}" var="person">
        <e:column>
                <f:facet name="header">
                        <e:cell value="name"/>
                </f:facet>
                <e:cell value="#{person.name}"/>
        </e:column>
        <e:column>
                <f:facet name="header">
                        <e:cell value="First Name"/>
                </f:facet>
                <e:cell value="#{person.firstName}"/>
        </e:column>
       
        <ui:repeat value="#{person.listTel}" var="tel">
                <e:column>
                        <f:facet name="header">
                                <e:cell value="Mobile Phone"/>
                        </f:facet>
                        <e:cell value="#{tel.mobile}"/>
                </e:column>      
                <e:column>
                        <f:facet name="header">
                                <e:cell value="Work Phone"/>
                        </f:facet>
                        <e:cell value="#{tel.work}"/>
                </e:column>
        </ui:repeat>
</e:worksheet>`

I can export de persons list with name, first name but i can't get their phone list...

Any idea which can help me to get this, please?

Thank you =)

[nickarls]

I'm not sure what you're trying to do, I don't see how that could be laid out correctly like that, say have 5 users and nr 4 has two mobile numbers, won't the second number of nr 4 end up in the place where one would expect the first number of nr 5 even if you could get it to work like that?

[mthai]

Thank you for reply
Actually, I give up dynamics columns in worksheet template, I make the datatable / dynamics columns with richfaces and I want to export with excelExporter.export()

I have an other issue
Follow this thread: http://www.seamframework.org/Community/ExportDatatableExcelWithLotOfData

Sorry for my english

[mthai]

Hi,

Sorry for no reply for long time, finally i used the rich:columns and use the seam excel component to export my datatable :)

Thank you :)