• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic