About Aspose.Cells for .NET

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Aspose.Cells for .NET is a Microsoft Excel spreadsheet programming API that helps to speed up spreadsheet management and processing. You can build cross-platform applications with the ability to generate, modify, convert, render and print spreadsheets. Moreover, It does not rely on Microsoft Excel or any Microsoft Office Interop components but is a robust set of APIs that deal with all Excel formats, as well as CSV and SpreadsheetML. By integrating the API, you can manage multiple worksheets, create spreadsheet contents and styles from scratch, import data, add common and complex Mathematical, Financial and Text formulas, manipulate charts, pictures, comments, drawing objects and much more.

Supported File Formats

Input/Output

  • Microsoft Excel: XLS, XLSX, XLSB, XLT, 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, EMF, GIF

Aspose.Cells for .NET Features

  • Save and open Excel files to and from streams.
  • Send output to a client browser.
  • Import and export data from a DataTable, DataView or Array.
  • 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.
  • Support for Office Open XML (OOXML).
  • Add a copy of an existing worksheet (with full contents, images and charts etc.) to a new file.
  • Set the gradient background for charts through the product API.
  • 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.
  • MS Excel sparklines.
  • Digital Signatures.
  • Support custom chart 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.
  • Optimize memory usage while working with large files via memory preference options.