How can I access spreadsheets in the open document format (.ods) with java?

jOpenDocument is all you need.

Take a look at jOpenDocument: http://www.jopendocument.org/documentation.html

Especially: http://www.jopendocument.org/start_spreadsheet_3.html