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


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

Output Only

  • Fixed Layout: PDF, PDF/A, XPS
  • Data Interchange: DIF

Aspose.Cells for Java Features:

  • Import and export data from ArrayList, Array & Recordset.
  • Chart creation & manipulation through the APIs.
  • Import formulas from a designer spreadsheet.
  • Generate and manipulate Named Ranges.
  • Print spreadsheets to a physical printer.
  • Populate worksheets through Smart Markers.
  • Create & manipulate comments.
  • Set & calculate Excel & custom formulas.
  • Create & manipulate conditional formatting rules.
  • Create & manipulate named ranges.
  • Create, manipulate & refresh Pivot Tables & Pivot Charts.
  • Rendering of charts & worksheets.
  • Read and write big files in the light-weight mode.
  • Re-sample images in Excel to PDF conversion.
  • Modify VBA code or Macros in the template document.