About Aspose.Cells for .NET

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Aspose.Cells for .NET is an Excel Spreadsheet Programming API that allows software developers to manipulate and convert spreadsheet files from within their own applications. A combination of APIs and GUI controls - Aspose.Cells for .NET speeds up Microsoft Excel programming and conversion. The Excel spreadsheet API gives developers powerful tools for performing simple file conversions or more complex tasks. Developers have control over page layout, formatting, charts and formulas. They can read and write spreadsheet files and save out to a variety of image, portable and text file formats.

Aspose.Cells for .NET Advanced Excel Spreadsheet API Features:

  • Ability to 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.
  • Save ODS file in ODF 1.1 and 1.2 specifications.
  • Optimize memory usage while working with large files via memory preference options.