• Post Reply Bookmark Topic Watch Topic
  • New Topic

write and read Excel File  RSS feed

 
varun bihani
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
I need to query a database and populate the excel
sheet with the results. this excel sheet needs to be
displayed in the browser. how do i go about doing
this? I am relatively new to JSP. any sample code
would be of great help.

Thanx and regards
 
Sripathi Krishnamurthy
Ranch Hand
Posts: 232
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
just do a select query and populate the results to a text file. Save the extension of that file as ".csv" extension. You will be able to open that in excel without any issues.
 
Poobhathy Kannan
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can make use of jakarat's poi.

Have a look here
 
Jeroen Wenting
Ranch Hand
Posts: 5093
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://www.javaranch.com and try the search functionality. You should find this asked (and answered) over and over again.

P.S. Just bringing the search under peoples' attention once again. It's woefully underused
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!