Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

excel from java

 
Cathy Song
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

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

Thanks,

Cathy.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 539
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Stan,

Does Jakarta POI fall into the latter category?

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


--Tim
 
Madeswaran Pachiyappan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
He wants to 'send' excel a csv-file, not to read...

How about

[ July 05, 2004: Message edited by: Stefan Wagner ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic