• Post Reply Bookmark Topic Watch Topic
  • New Topic

write and read Excel File

 
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!