Excel is actually a database in the backgroung. That is how all that formatting and formula information can be stored along with the actual contents of the cells. This link has an example of how to use JDBC to access Excel. http://www.javaranch.com/ubb/Forum3/HTML/000342.html
"JavaRanch, where the deer and the Certified play" - David O'Meara
It's weird that we cook bacon and bake cookies. Eat this tiny ad: