aspose file tools*
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
Author

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?

Thanks,

Cathy.
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 DanAdler.com. 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
Stan,

Does Jakarta POI fall into the latter category?

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


--Tim
Madeswaran Pachiyappan
Greenhorn

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..

http://www.4tops.com/excelimport.htm
http://www.macupdate.com/info.php/id/7119
http://www.devshed.com/c/a/MySQL/Using-Navicat-to-Import-Data-into-MySQL/
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/model/package-summary.html



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 ]

http://home.arcor.de/hirnstrom/bewerbung
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: excel from java