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?
You can use:
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!