Write to and read from Excel file

Hermione Krum

Greenhorn

Posts: 3

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

How can I write to and read from an Excel file??
Please help and thx!!!

Paul Stevens

Ranch Hand

Posts: 2823

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Make it a csv file.

Cindy Glass

"The Hood"

Posts: 8521

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Life just hasn't been the same since the volcano erupted and now the air is full of tiny ads.

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing