Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted Excel files, macros, VBA, Unicode, formula settings, pivot tables, and importing data from JDBC ResultSet. CSV, SpreadsheetML, PDF, ODS, and all file formats from Excel 97 to Excel 2007 are supported. It supports all advanced features of data management, formatting, worksheet, charting, and graphics.

Changes:
This release supports inserting pictures based on cell references in a worksheet. The data in the picture is reflected accordingly when you update the source cell's range. You can now also detect a category numberís formatting type. This release fixes an issue regarding JDK1.7 versions for chart-to-image, sheet-to-image, and Excel-to-PDF rendering. Several other important issues, including ones related to Microsoft Excel file formats (reading/writing), rendering PivotTables, rendering charts, manipulating worksheets, and rendering to the PDF format have been resolved.

URL:
Aspose.Cells for Java ‚Äď Freecode