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


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.

Utilize Smart Markers Grouping and Sorting Data Features, Support for JDK1.7 and LightCells APIs Included in Aspose.Cells for Java 7.0.2 | Blogs -