Import Data from MS Excel using Java Source Code

Question

I want to Import data placed in MS Excel and print it using Java Application Program. I am newbie in Java. So Please guide, is it possible.

If yes, how? Any website/tutorial will be of great help..

Thanks in advance..

Answer 1

You can use the jexcel APIs. They're quite simple overall. http://jexcelapi.sourceforge.net/

I also think that Apache POI is working on this area as well.

Answer 2

You can use the POI library for reading from excel files

Answer 3

Here is an article on using JDBC using Excel as a data source

Answer 4

Also, one more thing.

This kind of connectivity that Mr. TofuBeer has given, will work only when u are using single PC.. But when you need to design a web-based application i.e. using Servlets or JSP than these settings won't work??

Does there exist any Java package? Please forward any tutorial for that..

thanx in advance...

Answer 5

Why not export it from Excel in some format that is not proprietary? If the data is not too complex, even CSV might do the trick.