File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Kiran Chintha
Greenhorn
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic