Web tier: servlets, JSP, Web frameworks: Servlet producing Excel report!
- Posted by: pratap sinha
- Posted on: June 24 2005 05:00 EDT
In case of huge data, I am facing problem in the servlet to display it in excel format. For example, I am unable to show 80,000 record with each of 2KB(total ranges between 100-200MB at most)to excel format.
is there any solution to this?
I am seeing in the task manager that even though the excel application makes use of 100% of CPU usage but unable to deliver the report.
Excel can not have more than 65,536 rows in a single work sheet.
Now I am unable to display 47370 records..Can you please tell me at least how can I display such no of records at least till 65536.