JExcelApi

Java Excel API - A Java API to read, write, and modify Excel spreadsheets

Java Excel API is a mature, open source java API enabling developers to read, write, and modifiy Excel spreadsheets dynamically. Now java developers can read Excel spreadsheets, modify them with a convenient and simple API, and write the changes to any output stream (e.g. disk, HTTP, database, or any socket).

Any operating system which can run a Java virtual machine (i.e., not just Windows) can both process and deliver Excel spreadsheets. Because it is Java, the API can be invoked from within a servlet, thus giving access to Excel spreadsheets over internet and intranet web applications.

Some Features

Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks

Reads and writes formulas (Excel 97 and later only)

Generates spreadsheets in Excel 2000 format

Supports font, number and date formatting

Supports shading, bordering, and coloring of cells

Modifies existing worksheets

Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, Spanish, and German, but more can be added if translated)

Supports copying of charts

Supports insertion and copying of images into spreadsheets

Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc

...and much more

Resources

The following resources are available:

Java Docs

Andy Khan's Home Page

tutorial

tech notes

UML Diagrams

Forum/Mailing List with searchable archives

FAQ

IAQ (infrequently asked questions, but useful nonetheless)

There is also sample code included in the download