Java Excel API

Additionally it has a mechanism to allow Java applications to read a spreadsheet, modify some cells and write out the new spreadsheets.

This API allows non Windows operating systems to run pure Java applications which can both process and deliver Excel spreadsheets.

Because it is Java, this API may be invoked from within a servlet, thus giving access to Excel functionality over internet and intranet web applications.

Features:

• Supports font, number and date formatting
• Supports shading and coloring of cells
• Modifies existing worksheets
• Supports image creation
• Preserves macros on copy
• Customizable logging
• Reads data from Excel 95, 97, 2000 workbooks
• Reads and writes formulas (Excel 97 and later only)
• Generates spreadsheets in Excel 2000 format

What is new in this release:

• Incorporated the patch from Olivier for improved reading of headers and footers.
• Added the facility to make cells read only by using the formula ="". Had to change the setDataValidationRange function to accept empty strings.
• Fixed a bug whereby adding an image messed up data validation - had to explicitly add in a combo box drawing when data validation is present.
• Added null check for DVParser in addCell method in RowRecord.
• Improved the handling for skipping unsupported object types: read the unprocessed records and added them to the drawing data so that it prevented the system from crashing.

Limitations:

• JExcelApi does not generate or chart, graph or macro information.