Edition Types

Edition Types

Features Aspose.Cells
General  
Written Completely in C# Yes
.NET Environment required Yes
Platforms Supported  
Desktop applications Yes
Web applications Yes
Documentation  
Microsoft Help 2 Yes
Html Help Yes
Fully Featured Demos  
Visual Basic.NET Yes
C# Yes
Working Examples  
Visual Basic.NET Yes
C# Yes
Excel Creation  
Using Designer Spreadsheet Yes
Using API Yes
Smart Marker Yes
File Formats Supported  
Excel 97 Yes
Excel 2000 Yes
Excel XP Yes
Excel 2003 Yes
Excel 2007, 2010, 2013 XLSX Yes
Excel 2007, 2010, 2013 XLSM Yes
Excel 2007, 2010, 2013 XLTM Yes
Excel 2007, 2010, 2013 XLTX Yes
Pdf Yes
CSV Yes
Tab Delimited Text Yes
SpreadsheetML Yes
HTML Yes
ODS Yes
XPS Yes
Aspose.Pdf.xml format (that can be used by Aspose.Pdf to create PDF files) Yes
Spreadsheet Content  
Cell Data Yes
Formula Yes
Hyperlinks Yes
Data Validations Yes
Apply Formatting  
Cell Formatting Yes
Conditional Formatting Yes
Apply Formulae & Functions  
Using Designer Spreadsheet Yes
Using API Yes
Create & Access Named Ranges  
Using Designer Spreadsheet Yes
Using API Yes
Configure Page Setup Options  
Using Designer Spreadsheet Yes
Using API Yes
Document Properties  
Using Designer Spreadsheet Yes
Using API Yes
Managing Rows & Columns  
Insertion & Deletion Yes
Hiding & Unhiding Yes
Grouping & Ungrouping Yes
Worksheet Protection  
Using Designer Spreadsheet Yes
Using API Yes
Workbook Encryption  
Open Encrypted File Yes
Auto-Filtering of Data  
Using Designer Spreadsheet Yes
Using API Yes
Drawing Objects  
Pictures Yes
Standard Charts Yes
Custom Charts Yes
Comments Yes
Text Boxes Yes
Check Boxes Yes
Ole Objects Yes
AutoFit Rows & Columns  
Using Designer Spreadsheet Yes
Using API Yes
Add-ins Supported  
Using Designer Spreadsheet Yes
Using API Yes
VBA Supported  
Using Designer Spreadsheet Yes
Pivot Tables  
Using Designer Spreadsheet Yes
Using API Yes
Formula Calculation Engine  
Using API Yes

Aspose.Cells.GridDesktop and Aspose.Cells.GridWeb Features Availability

The following table summarizes the features available in Aspose.Cells.GridDesktop and Aspose.Cells.GridWeb controls provided by Aspose.Cells for .NET.

Features Aspose.Cells.GridDesktop Aspose.Cells.GridWeb
General    
Written completely in C# X X
Works with .NET Framework 1.1 and 2.0 X X
Platforms Supported    
Windows Forms applications X  
Web Forms applications   X
Documentation    
Microsoft Help 2 X X
Html Help X X
Online Programmer’s Guide in HTML format X X
Fully Featured Demos    
Visual Basic.NET X X
C# X X
Microsoft Excel Supported    
Microsoft Excel 97 X X
Microsoft Excel 2000 X X
Microsoft Excel XP X X
Microsoft Excel 2003 X X
Microsoft Excel 2007 X X
Browsers Supported    
Microsoft Internet Explorer X X
Mozilla X X
FireFox X X
Opera X X
Opening & Saving Spreadsheets    
Open a Spreadsheet in Grid X X
Save Grid data as a Spreadsheet X X
Load data from DataTable/DataView to the Grid X X
Save Grid data to DataTable/DataView X X
Managing Worksheets    
Add/Insert/Remove Worksheets X X
Rename Worksheets X X
Sort Worksheet data X X
Supports Worksheet Pagination   X
Managing Rows & Columns    
Add/Insert/Remove Rows and Columns X X
Hide/Show Rows and Columns X X
Freeze/Unfreeze Rows & Columns X X
Customize Rows & Columns Headers   X
Managing Cells    
Standard Format Settings of Cells X X
Custom Format Settings of Cells   X
Text Alignment of Cells X X
Border Settings of a Cell X X
Font Settings of a Cell X X
Merge or Split Cells X X
Formatting Settings    
Format Cells using Format Painter X  
Control the Look & Feel of the Grid X X
Built-in & Customizable Visual Styles   X
Data Validation    
Regular Expressions Validations X X
DropDownList Validations   X
Custom Validations X X
Comments    
Add/Remove Comments of Cells X X
Pictures    
Add/Remove Pictures in Cells X X
Hyperlinks    
Add/Remove Hyperlinks in Cells X X
Keyboard Navigation    
Keyboard Navigation in Cells X X
Controls    
Add/Remove Button , CheckBox & ComboBox controls in Cells X  
Security    
Lock or Hide Cells X  
Functions & Formulas    
Create & Calculate Formulas X X
80+ Pre-Defined Functions X X
Pivot Tables    
Create Dynamic Pivot Tables   X
Grid Events    
Handle Grid Events X X
Sessionless Mode    
Use Grid in Sessionless mode   X