Feature Overview

Supported Platforms

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

FeatureDescription
.NET FrameworkUse 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.0The ‘netStandard’ folder contains assembly to use with framework that implement .NET Standard 2.0 such as .NET Core 2.0.
Xamarin.AndroidUse Aspose.Cells for .NET in your native Android applications.
Xamarin.iOSUse Aspose.Cells for .NET in your native iOS applications.
COMCan be a lifesaver if you have to develop using pre- .NET technologies.
MonoYou can use Aspose.Cells for .NET to build applications with Mono.
Windows AzureAspose.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.

FeatureDescription.NET.NET Standard 2.0 
High-quality conversionsQuickly and reliably convert between several popular document formats.ticktick
Microsoft Excel workbook (XLS)The fastest and most complete XLS format implementation you can find.ticktick
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.
ticktick
Comma Separated Value (CSV)Comprehensive support of the CSV format to interact with a variety of applications.ticktick
TSVLoad and save documents in the TSV file format.ticktick
HTMLSave as HTML is available.ticktick
OpenDocument - ODSAspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format.ticktick
Converting to PDF filesConvert any Spreadsheet to PDF with high fidelity.ticktick
Tab delimitedLoad and save documents in the tab delimited file format.ticktick
Plain text (TXT)Easily extract text by saving in plain text format.ticktick
XPS documentConvert Excel spreadsheet to XPS documentticktick
Converting worksheet to image & worksheet to image by pageThe spreadsheets can also be exported to Tagged Image File Format (TIFF) with any desired compression types.ticktick

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

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.ticktick
Add a copy of existing worksheet (all contents including images, charts, other objects, etc.)ticktick
Copy or move worksheets within or between workbooksticktick
Insert imagesticktick
Create chartsticktick
Set gradient background for charts using APIticktick
Add comments to cellsticktick
Microsoft Excel 2007 themes and colorsticktick
Create auto-filtersticktick
Implement data validationsticktick
Implement data sortingticktick
Find and replace textticktick
Merge/split cellsticktick
Group/ungroup rows and columnsticktick
Create custom page breaksticktick
Insert/delete or hide rows, columns, and sheetsticktick
Calculate complex Excel formulaeticktick
Support advanced conditional formatting supported in Microsoft Excel 2007ticktick
Freeze/unfreeze Panesticktick
Insert hyperlinks to link dataticktick
Implement Smart Markersticktick
Specify document property settingsticktick
Protect/unprotect Worksheetsticktick
Specify advanced protection options introduced in Excel XP and later versionsticktick
Create list object/Microsoft Excel tablesticktick
Create subtotalsticktick
Insert form controls and other drawing shapes/objectsticktick
Create pivot tables and pivot chartsticktick
Preserve or remove addin, VBA, macrosticktick
Manipulate named rangesticktick
Implement transpose optionsticktick
Create custom chartsticktick
Add, preserve or extract OLE objects from the spreadsheets.ticktick
Implement Microsoft Excel 2010 sparklinesticktick
Encrypt filesticktick

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

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