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 allows Java developers to restrict the API to use only one font location while rendering spreadsheets. It is now possible to export or prevent exporting of hidden worksheet contents when saving a worksheet to HTML, and to set the display option for empty cells inside the Pivot Table to any specified string. A couple of problems with rendering spreadsheets as PDF on Linux, exporting spreadsheets to HTML, print quality, and page setup were fixed.
Release Notes: This new release lets developers control the direction of the text in shapes, including spreadsheet comments. Direction can be left to right, right to left, or to context. Images can now be controlled when exporting to HTML format. Bugs in rendering PivotTables as PDF, range references, deleting columns, and AutoFitRows with different font settings were fixed.
Release Notes: This release supports memory optimization for existing worksheets. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Excel spreadsheets containing huge data sets. This release enhances the licensing mechanism and adds the capability to identify potentially damaged or corrupted files. It fixes several important issues, such as a couple of problems related to the PDF rendering engine, rendering and manipulating charts, and retrieving and removing OleObjects. There is an overhaul of the existing formula engine.
Release Notes: Supports optimizing memory usage when working with big MS Excel files and large data sets (when building a workbook with large data sets, or reading a big template file). Sometimes developers may need to set their desired custom DateTime for the PDF files. This release allows getting or setting time for generating PDF documents during Excel to PDF conversion. Moreover, it also supports another valuable MS Excel features for showing formulas instead of the calculated values in a worksheet. Bugs in reading and writing Excel files and rendering images from worksheets have been fixed.
Release Notes: This release enables Java developers to read password-protected Microsoft Excel 2013 files and apply the justify distributed setting while applying text alignment settings on cells inside their own applications. It also provides support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeTypes. It enhances the un-hiding of rows/columns, printing comments in a Microsoft Excel document while rendering to PDF, and chart-to-image and sheet-to-image modules, and fixes issues with manipulating charts and shapes, exporting Excel workbooks to PDF format, and much more.