aspose file tools*
The moose likes JDBC 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
Reply locked New topic
Author

Need help to solve one java program

RoniArindam Ghosh
Greenhorn

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: 14150
    
  18

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 7 API documentation
Scala Notes - My blog about Scala
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
Saloon Keeper

Joined: Jul 29, 2008
Posts: 3101
    
  40

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
 
jQuery in Action, 2nd edition
 
subject: Need help to solve one java program