Feature Overview

The tables below summarize Aspose.Cells for .NET features and provide links to detailed feature descriptions.

Supported Platforms

Aspose.Cells for .NET product covers most of the popular development environments and deployment platforms. 

Feature	Description
.NET Framework	Use Aspose.Cells for .NET to build ASP.NET, Web Services, WinForms or any other type of application for any .NET Framework versions 2.0 or later including Client Profile versions. Full support for 32-bit and 64-bit.
.NET Standard 2.0	The ‘netStandard’ folder contains assembly to use with framework that implement .NET Standard 2.0 such as .NET Core 2.1/3.1. The latest version of Aspose.Cells API also supports .NET 5.0 and .NET 6.0.
COM	Can be a lifesaver if you have to develop using pre- .NET technologies.
Mono	You can use Aspose.Cells for .NET to build applications with Mono.
Windows Azure	Aspose.Cells for .NET also runs on Windows Azure.

File Formats and Conversions

Many customers worldwide rely on the thorough document import and export features provided by Aspose.Cells for .NET.

Feature	Description	.NET	.NET Standard 2.0
High-quality conversions	Quickly and reliably convert between several popular document formats.
Microsoft Excel workbook (XLS)	The fastest and most complete XLS format implementation you can find.
SpreadsheetML (XLSX, XML)	Aspose.Cells supports OOXML, Flat OPC and also Excel 2003 XML. Moreover, the component supports all the major Excel 2007, 2010 and 2013 file formats for example XLSX, XLTX, XLSM, XLTM etc.
Comma Separated Value (CSV)	Comprehensive support of the CSV format to interact with a variety of applications.
TSV	Load and save documents in the TSV file format.
HTML	Save as HTML is available.
OpenDocument - ODS	Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format.
Converting to PDF files	Convert any Spreadsheet to PDF with high fidelity.
Tab delimited	Load and save documents in the tab delimited file format.
Plain text (TXT)	Easily extract text by saving in plain text format.
XPS document	Convert Excel spreadsheet to XPS document
Converting worksheet to image & worksheet to image by page	The spreadsheets can also be exported to Tagged Image File Format (TIFF) with any desired compression types.

Rendering and Printing

Aspose.Cells for .NET now provides high fidelity rendering of spreadsheet pages.

Feature	.NET	.NET Standard 2.0
Layout document into pages with high fidelity to Microsoft Excel® (exactly like Microsoft Excel® would do that).
Render worksheet pages to raster images (TIFF, multipage TIFF, PNG, JPEG, BMP).
Render spreadsheet pages to vector images (EMF).
Specify image resolution, quality, compression, and other options.
Print spreadsheets using the .NET printing infrastructure. The component has a built-in print method to print the worksheets as shown in Microsoft Excel’s Print Preview.
Update page numbers and other fields before rendering or printing.

Spreadsheet Content Features

Aspose.Cells for .NET provides a rich object model that consists of over 100 public classes, which allow you to programmatically generate, combine, modify, parse or otherwise examine loaded spreadsheets. Some key features are given in the below table.

Feature	.NET	.NET Standard 2.0
Import/export data from a DataTable, DataView, Array, DataGrid etc.
Add a copy of existing worksheet (all contents including images, charts, other objects, etc.)
Copy or move worksheets within or between workbooks
Insert images
Create charts
Set gradient background for charts using API
Add comments to cells
Microsoft Excel 2007 themes and colors
Create auto-filters
Implement data validations
Implement data sorting
Find and replace text
Merge/split cells
Group/ungroup rows and columns
Create custom page breaks
Insert/delete or hide rows, columns, and sheets
Calculate complex Excel formulae
Support advanced conditional formatting supported in Microsoft Excel 2007
Freeze/unfreeze Panes
Insert hyperlinks to link data
Implement Smart Markers
Specify document property settings
Protect/unprotect Worksheets
Specify advanced protection options introduced in Excel XP and later versions
Create list object/Microsoft Excel tables
Create subtotals
Insert form controls and other drawing shapes/objects
Create pivot tables and pivot charts
Preserve or remove addin, VBA, macros
Manipulate named ranges
Implement transpose options
Create custom charts
Add, preserve or extract OLE objects from the spreadsheets.
Implement Microsoft Excel 2010 sparklines
Encrypt files

Spreadsheet Formatting Features

Aspose.Cells for .NET provides detailed programmatic access to formatting properties of all spreadsheet elements.

Feature	.NET	.NET Standard 2.0
Apply all characters formatting in the cells including fonts, colors, effects, borders, and shading.
Apply all the number format settings supported by Microsoft Excel to cells.
Set all types of text alignment settings.
Apply different kinds of font settings for the cells.
Apply different colors to cells, fonts, gridlines, graphic objects, etc.
Apply different rich text formatting in a single cell.
Apply different border settings on cells.
Apply different background patterns on cells.
Apply format settings on a worksheet, row, column or a range of cells, etc.

PageSetup Features

You can use Aspose.Cells for .NET to implement PageSetup options for your worksheets.

Feature	.NET	.NET Standard 2.0
Adjust your page orientation, scaling, paper size.
Specify your margins and page centering.
Create or edit your header and/or footer.
Set print area, print titles, or turn on gridlines, etc.