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, 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
  • Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF
  • Others: MARKDOWN, SQL, XTHML

Aspose.Cells for .NET Features

  • Send output to a client browser.
  • Import/export data to & from DataTable, DataView or Array.
  • Add & manipulate charts & PivotTable through the product API.
  • Import formulas from a designer spreadsheet.
  • Truncate long sheet name & replace invalid characters at run-time.
  • Apply text alignment to partial text inside the TextBox.
  • Paste rows & columns with advanced paste options.
  • Support for CSV (comma-separated values) & TSV (tab-separated values).
  • Create & manipulate comments.
  • Set auto-filters & page breaks.
  • Specify conditional formatting rules.
  • Create & manipulate named ranges.
  • Create & render sparklines.
  • Export worksheets to SVG format.
  • Read & write large spreadsheets in light-weight mode.
  • Re-sample images in Excel-to-PDF conversion.
  • Modify VBA code or Macros in the template file.
  • Populate spreadsheets via Smart Markers.