5

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

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

Thanks and Regards.

Tapas Bose
  • 28,796
  • 74
  • 215
  • 331
  • As per requirement of my project I need HTML, PDF and aforesaid spreadsheet file formats. – Tapas Bose May 21 '11 at 10:07
  • Just a note: you can manipulate Google Docs (including spreadsheets) using Java APIs and once your documents are in Google Docs you can a **lot** of thing with them. We recently a huge part of our document processing/managing to Google Docs and we're not looking back. Maybe something to look into. – SyntaxT3rr0r May 21 '11 at 10:20
  • @SyntaxT3rr0r, is this locally or on a Google server? – Thorbjørn Ravn Andersen May 21 '11 at 11:52
  • @Thorbjørn Ravn Andersen: well out of convenience (multiple people can open/edit the documents, history without needing to rollback from our VCS, etc.) we keep the "original" Google Docs on servers (we're not working with classified data ; ) but we do checkout local backups etc. These document can at least be exported to *.xls, .pdf, .txt, .csv, .html, .ods* etc. Maybe not (yet?) .xlsx. But I'm just saying this is something to look into: for us the benefits were so huge that we decided to adapt our way of working. – SyntaxT3rr0r May 21 '11 at 14:56

3 Answers3

2

Have you tried the OdfToolkit? I haven't used it but it sounds like something you need.

Matthew Flynn
  • 2,210
  • 19
  • 27
extraneon
  • 23,575
  • 2
  • 47
  • 51
1

For pdf generation you can use apache fop and altova stylevision to generate xsl-fo files. For xls - there is apache poi and jxls for templating.

sidslog
  • 654
  • 1
  • 6
  • 15
0

For .ods I am using Simple ODF.

Update

Simple ODF is moved to Apache. New link is here.

Tapas Bose
  • 28,796
  • 74
  • 215
  • 331