Aspose.Cells for Java Advanced Java Excel Spreadsheet API Featuress:

• Ability to save and open Excel files to and from streams.
• Send output to a client browser.
• Save and open ODS format files.
• Import and export data from an Array, ArrayList and Recordset.
• Import images and charts.
• Create images and charts through the product API.
• Import formulae from a designer spreadsheet.
• Configure page setup through the product API.
• Support of the CSV format.
• Add a copy of an existing worksheet (with full contents, images and charts etc.) to a new file.
• Create comments.
• Auto-filters and page breaks through the product API.
• Set complex formulae.
• Support conditional formatting.
• Support protection options introduced in Microsoft Excel XP.
• Manipulate named ranges.
• Create PivotTables through the product API.
• Save as HTML files or streams.
• MS Excel sparklines.
• Support custom charts through the product API.
• Formula calculation engine.
• Exporting worksheets to SVG files.
• Reading / writing large spreadsheets in light-weight mode.
• Re-sample images in Excel-to-PDF conversion.
• Tracing Precedents and Dependents.
• Create and manipulate Scenarios.
• Modify VBA code or Macros in the template file.
• Save ODS file in ODF 1.1 and 1.2 specifications.
• Optimize memory usage while working with large files via memory preference options.