Servlet producing Excel report!


Web tier: servlets, JSP, Web frameworks: Servlet producing Excel report!

  1. Servlet producing Excel report! (2 messages)

    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.

  2. Servlet producing Excel report![ Go to top ]

    Excel can not have more than 65,536 rows in a single work sheet.
  3. Servlet producing Excel report![ Go to top ]

    well rich,
    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.