PrimeFaces DataExporter for big data

Question

I have 65000 data for getting from DB into excel.But PF DataExporter component is not writing big data into the excel.What can I use for this process?Is there a library for this process?

Answer 1

You can use:

1. Apache POI Some examples - Quick guide very easy to use and excellent simple examples
2. Jasper reports Just link - needs some time to figure it out

If you need just one excel export, use Apache POI.

If you have a lot of reports, i would recommend you to use Jasper reports because you can have option to export it to PDF, Excel, Word and other formats.

Good luck!