Aspose.Cells for .NET

Aspose.Cells for .NET

Aspose.Cells for .NET is an Excel Spreadsheet Programming API allowing 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 the spreadsheet processing and conversion tasks.

Aspose.Cells for .NET contains APIs to be used with .NET Framework, .NET Core & Xamarin platform, empowering you to build cross-platform applications having the ability to generate, modify, convert, render and print spreadsheets without using Microsoft Excel.

An overview of Aspose.Cells for .NET capabilities.

• Convert Chart to Image

• Convert Worksheet to Image

• Convert Spreadsheet to PDF

• Printing

• Apply Formatting

• Create Charts

• Apply Formulas

• Summarize

• Smart Markers

• Desktop Control for WinForms

• Web Control for ASP.NET

• Apply Formatting

• Apply Formulas

• Import/Export Data

Advanced Excel Spreadsheet API Features

Aspose.Cells for .NET includes the following features:

Ability to save & load Excel files to & from streams

Send output to a client browser

Import & export data to & from DataTable, DataView or Array

Configure page setup through the product API

Create charts through the product API

Import formulas from a designer spreadsheet

Aspose.Cells for .NET also supports a number of unique features that developers can only find in this API:

Support for CSV (comma-separated values) & TSV (tab-separated values)

Support for Office Open XML (OOXML) formats

Create copies of existing worksheets

Set the gradient background for charts

Create & manipulate comments

Set auto-filters & page breaks

Set & calculate complex formulas

Specify conditional formatting rules

Set protection options introduced in Microsoft Excel XP

Create & manipulate named ranges

Create & render sparklines

Add Digital Signatures

Create & render custom charts

Formula calculation engine

Export worksheets to SVG format

Read & write large spreadsheets in light-weight mode

Re-sample images in Excel-to-PDF conversion

Trace 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

Populate spreadsheets via Smart Markers

Dynamically create & manipulate Pivot Tables