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.1/3.1. The latest version of Aspose.Cells API also supports .NET 5.0, .NET 6.0, .NET 7.0 and .NET8.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. |