GeeCON Prague 2014*
The moose likes Other Open Source Projects and the fly likes using excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "using excel file" Watch "using excel file" New topic
Author

using excel file

randy butler
Greenhorn

Joined: Jan 20, 2009
Posts: 27
Guys/Gals

I want to write a program that is able to import data from an excel file and it can update the current mysql table. My question is how can add the import /update feature?

one other thing is that I want to do this in swing.

Thanks
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42047
    
  64
The common libraries for working with Excel files are Apache POI (for both XLS and XLSX) and jExcelApi (XLS only). I generally advise to use POI; even the beta versions of upcoming releases are quite stable.


Ping & DNS - my free Android networking tools app
randy butler
Greenhorn

Joined: Jan 20, 2009
Posts: 27
Thanks for the quick reply. can you point me in the direction the jar files for the Apache POI?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

In this case the obvious Google keywords ("apache poi") lead you directly to its home page.
randy butler
Greenhorn

Joined: Jan 20, 2009
Posts: 27
I'm only looking for HSSF XSSF and not sure which jar file to use from there list of mirrors
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42047
    
  64
You need the binary (not source) version of POI 3.5 beta. The 3.2 version does not have the XSSF stuff.
randy butler
Greenhorn

Joined: Jan 20, 2009
Posts: 27
Thanks for pointing me in the right direction.
 
GeeCON Prague 2014
 
subject: using excel file