I have a requirement for report generation using java coding, the report should be generated in an excel file.
For this report generation, originally the coding was in servelts and jsps and everything was kept in a session for each user, so there was so many problems related to sessions, after that the coding is completely migrated to a stored procedure and now the session related problem has got solved, but now the problem is when we run the report for larger data, the output is not generating to an excel file and the controller is showing as running but there isnt any output. Could you guys please suggest some ways so that i can follow to generate the reports (by fetching data from database), we are using servlets and JSP's in our application. We are using poi jar file for report generation in excel.
I guess it reaches excel file limitation(65000 approx).In that case you need to split excel sheet into multiple sheets.
Joined: Jul 25, 2009
Thanks for your suggestion, i hope we need to check the limitation and need to write the data to a new excel sheet, and can you suggest any other ways this can be accomplished, as an alternative, i need to have a seperate way of implementation for generation of this report, like when the user click the report generation button, needs to call a cron job in unix which will take care of generation of report in excel, and this will be running in equal intervals of time like 5 - 10 mins and when it finds any request it should generate the report and place it in some location in unix box and intimate the user once the report is generated.