aspose file tools*
The moose likes Other Open Source Projects and the fly likes Generating an excel report from java by fetching the data from database. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Generating an excel report from java by fetching the data from database." Watch "Generating an excel report from java by fetching the data from database." New topic
Author

Generating an excel report from java by fetching the data from database.

Kiran Chintha
Greenhorn

Joined: Jul 25, 2009
Posts: 15
Hi Pals,
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.


Thanks
Kiran
satishbsk kumar
Greenhorn

Joined: Jul 24, 2009
Posts: 15
Kiran,
I guess it reaches excel file limitation(65000 approx).In that case you need to split excel sheet into multiple sheets.
Regards,
Satish
Kiran Chintha
Greenhorn

Joined: Jul 25, 2009
Posts: 15
Hi Satish,
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.

Thanks
Kiran
micheal hallowen
Greenhorn

Joined: Aug 19, 2013
Posts: 2
I think you should try simreport library in jsimreport.com to make excel report in java using servlet and jsp. I see it is simple and flexible enough to help you to make excel report.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Generating an excel report from java by fetching the data from database.