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.
"JavaRanch, where the deer and the Certified play" - David O'Meara
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.
Create symphonies in seed and soil. For this tiny ad:
a bit of art, as a gift, the permaculture playing cards