Tags: anyhow, contents, excel, java, sheet
how to read contents from an excel sheet using java
On Java Studio » Java Knowledge
770 words with 3 Comments; publish: Sun, 13 Jul 2008 17:49:00 GMT; (15046.88, « »)
hi all,
can anyhow help me of how to read the contents from an excel sheet using java technology.
thanks and regards
dinakar.sm
http://java-knowledge.developerfaqs.com/q_java-tech_39169.html
All Comments
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