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 |
| Implementation | Java |
Recent releases


Release Notes: This release includes a useful feature for checking if a column is blank. It also makes enhancements to the LightCells APIs so that you can now create huge XLSX files quickly. It also enhances the formula calculation engine and sorts out a few formulas. The Excel-to-PDF feature has been improved. Custom Number format: "dd.MM.yyyy" is now saved correctly for ODS files and the ROUND function now rounds a value greater than 922337.20.


Release Notes: This release includes a number of useful enhancements, like pivot table handling and XLSX and ODS formats. It also fixes issues regarding shapes, XLS, XLSX, and ODS rendering. Moreover, the Excel-to-PDF feature is further improved in this release. Sheet’s zoom is fixed when opening an XLS template file. Saving to PDF is fixed. Number format loss is fixed when saving to ODS file format.


Release Notes: This release added support for reading HTML files, and for reading charts and other shapes in ODS files. The worksheet’s copy operation was enhanced, and more useful options were provided for copying worksheets between workbooks. Text and CSV files can be loaded with your desired parsers. Advanced conditional formatting for XLS files was improved. There were also some other fixes and enhancements.


Release Notes: XLS and XLSX files can now be saved in Light Cells mode using LightCellsDataProvider. This gives users better performance for bigger files. The Excel to PDF conversion feature was improved. Clashes between Aspose.Cells for Java and other JARs it was using (specifically woodstoxs-core and webservices-rt) were resolved. A new method was added for getting a list of colors for different objects used in a worksheet.


Release Notes: This release has several enhancements, including improvements to the Sheet-to-Image and Excel-to-PDF features. It fixes a number of user issues. It adds support for group and sort data in the Smart Markers feature. Users can now place dynamic rows for sub-totals, totals, etc. in between the sections of data while grouping data for your scenarios. Moreover, it also includes support for JDK1.7 and LightCells APIs for saving XLSX files.