Java Spreadsheet API - Read Write Modify

Question

I need to create a spreadsheet in various file formats: .xls, .xlsx, .ods, csv. I want to know how I can achieve this in Java and about the open source APIs available.

I found the API for .xls, .xlsx, but not .ods. Any information would be very helpful.

Thanks and respect.

Answer 1

Have you tried OdfToolkit ? I have not used it, but it seems like what you need.

Answer 2

To create pdf, you can use apache fop and altova stylevision to generate xsl-fo files. For xls - apache poi and jxls for templated.

Answer 3

For .ods I use Simple ODF .

Update

Simple ODF moves to Apache. New link here .