File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes excel from java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "excel from java" Watch "excel from java" New topic

excel from java

Cathy Song
Ranch Hand

Joined: Jul 01, 2003
Posts: 92
Hi All,

How can I open excel from java and send it a .csv file?


Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
I know only two paths into Excel. First, it can act as an ODBC data source. You reference the file as the database, a named range as a table and rows & columns within the range as data. You can get to it from Java with JDBC-ODBC bridge. The other path is COM which we old folks used to call OLE. Google for "java com bridge". There are a bunch of products out there. The last time I surveyed, the commercial ones were huge and expensive. One free one is Jacob at SourceForge has one but I can never remember the name.

(OK, I left out DDE. It's been uncool since it was buggy in Windows 3.1 but I've built some very slick interfaces with it over the years. Again, you'd need a Java dde bridge, and there are some out there.)

A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Tim West
Ranch Hand

Joined: Mar 15, 2004
Posts: 539

Does Jakarta POI fall into the latter category?

I always had an idea that it was somehow more "pure"

Madeswaran Pachiyappan

Joined: Jun 29, 2004
Posts: 7
It seems few tools are available to import data from Excel to databases namely oracle, MS Sql, MySql etc....

Hope The following links may help you in accomplishing your requirement..

Madeswaran P,<br />Chennai,<br />TamilNadu.
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

He wants to 'send' excel a csv-file, not to read...

How about

[ July 05, 2004: Message edited by: Stefan Wagner ]
I agree. Here's the link:
subject: excel from java
jQuery in Action, 3rd edition