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: 15084

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: 3924

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 agree. Here's the link:
subject: Need help to solve one java program
It's not a secret anymore!