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: 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.
Release Notes: This release provides support to get a locale-based Date format for built-in Numbers. Now Macros/VBA codes are copied in the XSLM file when you use the Workbook.copy() method. The HTML rendering module has been improved. In this release, several important issues have been addressed. For example, issues around rendering Excel files and rendering image files have been resolved. Issues pertaining to the formula calculation engine have also been fixed.
Release Notes: This month’s release includes support for setting borders for a 3D chart’s side and back walls. It also provides support to assign and validate digital signatures. It includes a few enhancements regarding text alignments and error checking options in cells. This is also a maintenance release where several important issues have been fixed. Many issues around reading and writing spreadsheets, rendering drawing objects and shapes, page setup options, and exporting to PDF have been resolved.
Release Notes: This release supports specification of a custom encoding type when saving to HTML. It also enhances advanced conditional formatting when converting worksheets to image files, and an MS Excel ruler which is not displayed when setting Page Layout view. Performance of Excel to PDF rendering was enhanced. Several issues including rendering of spreadsheets (XLS, XLSX etc.), protecting sheets, rendering PivotTables, encrypting files, and exporting to PDF have been resolved. The GridWeb control now works smoothly with browsers other than Internet Explorer like Google Chrome, Firefox, Safari etc.
Release Notes: This release added support for rendering sparklines and for displaying RTL (right-to-left) languages in generated PDF files (Excel to PDF conversion). PDF rendering performance was enhanced by providing a PdfSaveOptions.CheckFontCompatibility option. The conditional formatting feature is also improved. Many issues with reading, writing, and converting spreadsheets (XLS, XLSX etc.), rendering or converting shapes, and exporting to PDF have been resolved. Issues pertaining to charts and the formula calculation engine have also been corrected.