Comparison with Other Solutions

Contents
[ ]
Feature Essential ExcelRW ComponentOne XLS for .NET SoftArtisans ExcelWriter Aspose.Cells
File Formats        
Native Excel File Format Yes Yes Yes Yes
CSV Format       Yes
Tab Delimited Text Format       Yes
SpreadsheetML Format       Yes
Convert Workbook to Pdf format       Yes
Convert Workbook to HTML file       Yes
Open File and Save to a Stream Yes Yes Yes Yes
Send Output to the Client Browser Yes   Yes Yes
Encrypt Excel Files Yes     Yes
Manipulate Spreadsheet Content        
Import Data from a DataTable Yes   Yes Yes
Export Data to a DataTable Yes     Yes
Import Data from a DataView       Yes
Import Data from an Array     Yes Yes
Import Data from DataGrid       Yes
Add a Copy of Existing Worksheet (all contents including Images, Charts etc.) Yes     Yes
Move Worksheets       Yes
Import Images & Charts     Yes Yes
Create Images & Charts using API Yes   Yes Yes
Set Gradient Background for Charts using API       Yes
Create Comments using API Yes   Yes Yes
Create Auto-Filters using API Yes     Yes
Data Validation Yes   Yes Yes
Data Sorting       Yes
Merge / Unmerge Cells Yes     Yes
Group / UnGroup Rows and Columns Yes     Yes
Create Page Breaks using API Yes Yes   Yes
Number Formats Yes Yes Yes Yes
Format Cells ( set background and foreground colors, apply borders around cells, adjust data alignment and set fonts with attributes ) Yes Yes Yes Yes
Import Formulae from Designer Spreadsheet Yes   Yes Yes
Set Complex Formulae through API Yes   Yes Yes
Support Advanced Conditional Formatting Yes   Yes Yes
Freeze / Unfreeze Panes Yes   Yes Yes
Create Hyperlinks Yes Yes Yes Yes
Advanced Features        
Smart Markers / Data Markers     Yes Yes
Document Properties Settings Yes   Yes Yes
Protect / Unprotect Worksheets Yes Yes Yes Yes
Excel XP Advanced Protection Options       Yes
Create List Object       Yes
Create Subtotals       Yes
Manage Ole Objects       Yes
Form Controls and Drawing Shapes Yes   Yes Yes
Pivot Tables Yes   Yes Yes
Addin, VBA, Macros Yes   Yes Yes
Manipulate Named Ranges Yes Yes Yes Yes
Page Setup API Yes Yes Yes Yes
Find API       Yes
Custom Chart API       Yes
Formula Calculation Engine       Yes
Utility Features        
Convert Chart to Image File       Yes
Convert Worksheet to Image File Yes     Yes
Print Worksheets       Yes