Export to Excel with ScrollableDataTable

[aish]

Hi,

I searched the forum for "Export to Excel" options and I found the (1) myapache POI for exportExcel and (2) jsf excelcreator to export data to excel. They both refer take the data source from DataTable.

In our project, we have used scrollableDataTable due to the volume of the data and no. of fields involved in it. Can you please let me know what excel export option is available for scrollableDataTable. This excel Export is an important option in our project. Can you please guide in the direction to implement this feature

Thanks
Aish

[konstantin.mishin]

ScrollableDataTable hasn't this feature.

[aish]

Hi,

I have to show table data with more than 100 fields and I do not have any other option other than scrollableDataTable. Export to excel is a mandatory feature for my users.

Can you please help me find a solution for this excel to export. If this is not available, I would be asked to change my entire application from RichFaces to some other technology or software that has this excel export feature.

Thanks
Aish

[nbelaevski]

Aish,

Have you considered Seam export options?

Are you having any particular problems using POI or ExcelCreator?

[aish]

Hi,

Thanks for responding.

I looked at POI but yet to try it since it mentioned only about dataTable and not scrollableDataTable.

Will Seam export option will work? I didn't know that until I saw your post

Aish

[nbelaevski]

I haven't tried that so I cannot say for sure whether it will run smoothly or not. Maybe someone from community will share his/her experience?