1

I want to know what my options are for writing Excel files using Java. I know about JXL and Apache POI. Are there others? And in your experience, which one is the best and which one is the most commonly used?

Improve this question

3 Answers 3

Reset to default
3

you can check the following projects:

  • JExcel: a very good java Excel api project

  • JExcelApi: another java api for excel

  • openoffice.org API project : you could manipulate Excel files using theOpenOffice API in different programming languages (c++ ,java etc)

  • ODF toolkit and jopendocument.org : see this article for more info about these two project

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

3

Apache POI offers very low level handling which you may find difficulty in, both development and maintenance.

You can also look into JasperReports or iText.

I have worked with both jasper reports and itext, I would say jasper report with drag and drop packed in the ireport ide feature to be most maintenance friendly.

I support itext for its documentation and programmatic way of rendering an pdf or excel.

Improve this answer

Comments

-1

A simple implementation for exporting tabular data to Excel is to create a CSV file. Excel will open this up like a regular Excel-file.

Improve this answer

Comments