File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using excel file

 
randy butler
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
randy butler
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the quick reply. can you point me in the direction the jar files for the Apache POI?
 
Paul Clapham
Sheriff
Pie
Posts: 20164
24
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In this case the obvious Google keywords ("apache poi") lead you directly to its home page.
 
randy butler
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm only looking for HSSF XSSF and not sure which jar file to use from there list of mirrors
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for pointing me in the right direction.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic