About Aspose.Cells for Java

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Aspose.Cells for Java is an Excel Spreadsheet Processing API that allows Java developers to embed the ability to read, write and manipulate Excel spreadsheets (XLS, XLSX, XLSM, XLSB, XLTX, SpreadsheetML, CSV, ODS), HTML, MHTML, PDF and image file formats into their own Java applications without needing to rely on Microsoft Excel. It is a mature, scalable and feature rich API, offering many functions that are way beyond simple data exporting capabilities. With Aspose.Cells for Java developers can export data, format spreadsheets to the most granular level, import images, create charts, apply and calculate complex formulas, stream Excel data, save in various formats and much more.

Supported File Formats

Input/Output

  • Microsoft Excel: XLS, XLT, XLSX, XLSB, XLTX, XLTM, XLSM, XML
  • OpenOffice: ODS
  • Text: CSV, TSV
  • Web: HTML, MHTML
  • Numbers: Apple's iWork office suite Numbers app documents

Output Only

  • Fixed Layout: PDF, PDF/A, XPS
  • Data Interchange: DIF
  • Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF

Aspose.Cells for Java Features:

  • 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.