This week's book giveaway is in the Spring forum.
We're giving away four copies of Spring in Action (5th edition) and have Craig Walls on-line!
See this thread for details.
Win a copy of Spring in Action (5th edition) this week in the Spring forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Ganesh Patekar
  • Frits Walraven
  • Tim Moores
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Stephan van Hulst
  • salvin francis
  • Tim Holloway

How to store an oracle database table's data to an excel file?  RSS feed

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am doing a small application using JSP, Servlets, Oracle DataBase express edition.
In this, I store some data into a particular table of the database from the application. The user of the application wants the data from that table to have it stored in an excel file.
To be specific, I have to provide an option for the user to delete a particular "vehicle" under operation from the application after its agreement expires. But the user wants all the data in an excel file.
How do I do it?
 
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Apache POI is how you would populate the Excel file. You can then stream this to the client. However, depending on their browser and its set up it will either give you a "save file" dialog or will render the Excel file in the browser.
 
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
oracle - excel
 
Nikhil Reddy Lingala
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I understood that I should use Apache POI API for my application in order to convert database tables to excel.
Do I need to do any pre-configuration for that? like writing an xml file... or that kind of stuff??
and one more thing.. how do I get the javadocs download for Apache POI?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by Nikhil Reddy Lingala:
I understood that I should use Apache POI API for my application in order to convert database tables to excel.
Do I need to do any pre-configuration for that? like writing an xml file... or that kind of stuff??
and one more thing.. how do I get the javadocs download for Apache POI?



Preconfiguration? No. Read through the POI docs, there are example and the like.

The JavaDocs are available online. I'm not sure if they are included in the download. You can always build them from the source though.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!