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

Do not meddle in the affairs of dragons - for you are crunchy and good with ketchup. Crunchy tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser