Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

excel from java

 
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,

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

Thanks,

Cathy.
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.)
 
Ranch Hand
Posts: 539
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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

 
Ranch Hand
Posts: 1923
Scala Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
reply
    Bookmark Topic Watch Topic
  • New Topic