using excel file

[randy butler]

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]

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]

Thanks for the quick reply. can you point me in the direction the jar files for the Apache POI?

[Paul Clapham]

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

[randy butler]

I'm only looking for HSSF XSSF and not sure which jar file to use from there list of mirrors

[Ulf Dittmer]

You need the binary (not source) version of POI 3.5 beta. The 3.2 version does not have the XSSF stuff.

[randy butler]

Thanks for pointing me in the right direction.