Key Features

No Microsoft Excel Automation

Aspose.Cells is an incredibly versatile component that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system.

Advanced Features

Aspose.Cells includes the following features:

• Ability to save and open Excel files to and from streams
• Send output to a client browser
• Import and export data from a DataTable, DataView or Array
• Import images and charts
• Create images and charts through the product API
• Import formulae from a designer spreadsheet
• Configure page setup through the product API

Platform Independence

You can confidently use Aspose.Cells to build any type of a 32-bit or 64-bit .NET application including ASP.NET, Web Services and WinForms.

Flexible Display Options

Aspose.Cells gives you complete control over page setup and allows you to manipulate a wide range of display options such as; preview page breaks and the zoom level for the Worksheet, control data visibility using Freeze Panes, set page orientation options, scaling, paper size, headers/footers, and print area etc.

Security features

Aspose.Cells offers a wide range of security features including; support for Excel 2007 XLSX file encryption/decryption, protect Contents, Objects and Scenarios of a Worksheet and the ability to hide and unhide a Worksheet. 

Manipulate Rows and Columns

Aspose.Cells allows you to manipulate Rows and Columns in many different ways. You can easily adjust Row height and Column width as required, auto size the width/height of cells according to contents, insert and delete, hide and unhide as well as group and ungroup Rows and Columns.

Data Management

Aspose.Cells provides extensive support for data management. You can easily manipulate any Cell in a Worksheet at runtime, import data into Worksheets from different data sources and export data to a DataTable.

Comprehensive Formatting Support

Aspose.Cells gives you absolute control over how your data is presented by offering advanced formatting features. You can apply individual formatting to a Worksheet, Row, Column, and Cell. You can also add Rich Text to a Single Cell and apply different Borders, Background Patterns and Fonts.

Creating Charts

Aspose.Cells comes with complete support for charting and supports all standard chart types. You can easily add customized charts using the product API and dynamically set data for charts. Aspose.Cells also allows you to convert charts to images.

Graphics Capabilities

Aspose.Cells provides extensive graphical capabilities, allowing you to easily convert Worksheets to images as well as adding images to Worksheets at runtime.

Support for many Different File Formats

Using Aspose.Cells, developers can easily open and save a multitude of file formats. These include

• Excel 97 / 2000 / XP / 2007 / 2010 (XLSX)
• SpreadSheetML
• Tab Delimited
• CSV
• Office Open XML (OOXML) SpreadsheetML file formats

Support for Office Open XML (OOXML)

Office Open XML (OOXML) is a container format for several specialized XML-based markup languages.  Aspose.Cells provides extensive support for loading, saving and converting SpreadsheetML documents.

Aspose.Cells Grid Suite

Aspose.Cells also provides a complete Grid solution for the customers, it has two GUI based .NET controls:

• Aspose.Cells.GridDesktop, that supports desktop applications.
• Aspose.Cells.GridWeb , that supports web applications.