how to read contents from an excel sheet using java
can anyhow help me of how to read the contents from an excel sheet using java technology.
thanks and regards
Leave a comment...
- 3 Comments
- Excel is basically treated as a database (it actually DOES have access databases running the show behind the spreadsheets and charts). Therefore you need to use an JDBC call. Do a search in the JDBC forum to find the syntax.#1; Sun, 13 Jul 2008 17:51:00 GMT
- If you know how to contact it's COM interface you can easily then call it's methods. I have done it in vb easily with Java never had a chance.#2; Sun, 13 Jul 2008 17:52:00 GMT
- Check out formula one product. http://www.tidestone.com.
They claim to provide (97%) of Excel functionality in their Java classes. I've used to view excel reports within my applets.#3; Sun, 13 Jul 2008 17:53:00 GMT