Feature Overview

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.0.
Xamarin.Android Use Aspose.Cells for .NET in your native Android applications.
Xamarin.iOS Use Aspose.Cells for .NET in your native iOS applications.
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. tick tick
Microsoft Excel workbook (XLS) The fastest and most complete XLS format implementation you can find. tick tick
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.
tick tick
Comma Separated Value (CSV) Comprehensive support of the CSV format to interact with a variety of applications. tick tick
TSV Load and save documents in the TSV file format. tick tick
HTML Save as HTML is available. tick tick
OpenDocument - ODS Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format. tick tick
Converting to PDF files Convert any Spreadsheet to PDF with high fidelity. tick tick
Tab delimited Load and save documents in the tab delimited file format. tick tick
Plain text (TXT) Easily extract text by saving in plain text format. tick tick
XPS document Convert Excel spreadsheet to XPS document tick tick
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. tick tick

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). tick tick
Render worksheet pages to raster images (TIFF, multipage TIFF, PNG, JPEG, BMP). tick tick
Render spreadsheet pages to vector images (EMF). tick tick
Specify image resolution, quality, compression, and other options. tick tick
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. tick tick
Update page numbers and other fields before rendering or printing. tick tick

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

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. tick tick
Apply all the number format settings supported by Microsoft Excel to cells. tick tick
Set all types of text alignment settings. tick tick
Apply different kinds of font settings for the cells. tick tick
Apply different colors to cells, fonts, gridlines, graphic objects, etc. tick tick
Apply different rich text formatting in a single cell. tick tick
Apply different border settings on cells. tick tick
Apply different background patterns on cells. tick tick
Apply format settings on a worksheet, row, column or a range of cells, etc. tick tick

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. tick tick
Specify your margins and page centering. tick tick
Create or edit your header and/or footer. tick tick
Set print area, print titles, or turn on gridlines, etc. tick tick