Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using excel file

 
randy butler
Greenhorn
Posts: 27
  • 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
Posts: 42967
73
  • 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
  • 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
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • 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
  • 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
Posts: 42967
73
  • 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
  • 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