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.
|Tags||Conditional formatting Extended records 3D effects MS Excel 2010 Sparklines SpreadSheeML charts|
|Licenses||Evaluation License Developer Enterprise License Developer OEM License Site Enterprise License Site OEM License|
|Operating Systems||Windows Unix Linux|
Release Notes: The dependency on the dom4j library has been removed and was replaced with a custom XML parser. A “Cannot find black listed licenses resource” exception was fixed. The OSGi environment is now supported without any problems. Exceptions when reading/writing Excel files and rendering Excel spreadsheets to image files and PDF format were resolved.
Release Notes: This release supports selecting a range of cells in the worksheet while activating the worksheets in the output Excel file. You may also specify a first page header and footer image for worksheet. There were a number of complaints regarding the image quality in chart-to-image conversion, and this release improves the quality to a certain extent. It also fixes issues with manipulating charts and shapes. Several other important issues have been addressed, for example, issues related to rendering MS Excel file formats, manipulating charts, manipulating worksheets, and rendering to PDF format.
Release Notes: This release includes some useful enhancements. For example, you may add conditional icons set (images) with your data to make it more meaningful. You may also auto-resize the textbox control based on the text or contents. The component now allows you to create a CellArea by using “$” included in the cell address. Several important issues related to rendering Microsoft Excel files, rendering charts, manipulating PivotTables, copying cells, inserting rows, and rendering to PDF format have been resolved. Issues pertaining to the formula calculation engine have also been fixed in this release.
Release Notes: 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.
Release Notes: This release provided support for missing fonts, resolved an issue caused by JBOSS and mixed case Java classes, and fixed issues with rendering Microsoft Excel files, rendering charts, manipulating worksheets, and rendering to PDF format have been resolved. Issues with the formula calculation engine have also been fixed.