This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Need help to solve one java program Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

Need help to solve one java program

RoniArindam Ghosh

Joined: Aug 22, 2007
Posts: 1
How can store data from an oracle data base table to Excel fromat using java program...

Please provide me the java program of this one...

Wait for reply...
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14950

You can use the JDBC API to connect to the Oracle database and read data from it.

There are a number of ways to handle Excel files in Java. Since the XLS file format is a proprietary Microsoft format, there is no official support for XLS files in Java. There are libraries which you can use to read and write XLS files such as Apache POI.

You could also make it easier for yourself by writing a simple CSV (comma separated values) file instead of an XLS file. Excel can read CSV files easily.

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
sonia arora
Ranch Hand

Joined: Mar 10, 2010
Posts: 31
i want to open a excel sheet on click of a button.
need urgent help please reply.
Devaka Cooray
ExamLab Creator

Joined: Jul 29, 2008
Posts: 3598

Sonia, please start a new topic for your question.
Locking this one.

Author of ExamLab ExamLab - a free SCJP / OCPJP exam simulator
What would SCJP exam questions look like? -- Home -- Twitter -- How to Ask a Question
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Need help to solve one java program
jQuery in Action, 3rd edition