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 Delimted Text Format

Yes

SpreadsheetML Format

Yes

Open File and Save to a Stream

Yes

Yes

Send Output to the Client Browser

Yes

Yes

Manipulate Spreadsheet Content

Import Data from a DataTable

Yes

Yes

Export Data to a DataTable

Yes

Import Data from a DataView

Yes

Import Data from an Array

Yes

Yes

Add a Copy of Existing Worksheet (all contents including Images, Charts etc.)

Yes

Import Images & Charts

Yes

Yes

Create Images & Charts using API

Yes

Yes

Set Gradient Background for Charts using API

Yes

Create Comments using API

Yes

Create Auto-Filters using API

Yes

Create Page Breaks using API

Yes

Import Formulae from Designer Spreadsheet

Yes

Yes

Set Complex Formulae through API

Yes

Supports Conditional Formatting

Yes

Advanced Features

Smart Marker

Yes

Document Properties Settings

Yes

Yes

Excel XP Protection Options