Win a copy of The Java Performance Companion this week in the Performance forum!
    Bookmark Topic Watch Topic
  • New Topic

Need help to solve one java program

 
RoniArindam Ghosh
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 15359
39
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
sonia arora
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Report post to moderator
i want to open a excel sheet on click of a button.
need urgent help please reply.
 
Devaka Cooray
ExamLab Creator
Marshal
Pie
Posts: 4502
268
Chrome Eclipse IDE Google App Engine IntelliJ IDE jQuery Postgres Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Report post to moderator
Sonia, please start a new topic for your question.
Locking this one.
 
    Bookmark Topic Watch Topic
  • New Topic