excel from java

[Cathy Song]

Hi All,

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

Thanks,

Cathy.

[Stan James]

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

[Tim West]

Stan,

Does Jakarta POI fall into the latter category?

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


--Tim

[Madeswaran Pachiyappan]

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

[Stefan Wagner]

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

How about

Runtime.getRuntime ().exec (new String [] {"PATH_TO_EXCEL/excel.exe", "PATH_TO_CSV_FILE/file.csv"});

[ July 05, 2004: Message edited by: Stefan Wagner ]