Feature comparison of Interop and XlsIO

Feature

XlsIO

Interop

File Formats

Excel File Format (.xls/.xlsx format)

Yes

Yes

CSV Format

Yes

Yes

Tab Delimited Text Format

Yes

Yes

SpreadsheetML Format

Yes

Yes

Convert Workbook to Pdf format

Yes

Yes

Convert Workbook to HTML file

Yes

Yes

Open File and Save to a Stream

Yes

No

Send Output to the Client Browser

Yes

No

XPS Document

No

Yes

OpenDocument Spreadsheet (*.ODS)

No

Yes

Excel Template (*.XLT/*.XLTX)

Yes

Yes

Excel Binary Workbook (*.XLSB)

No

Yes

Manipulate Spreadsheet Content

Import data from DataTable, DataColumn, DataView, Array and Business Objects to worksheet

Yes

Yes

Imports data from various external sources like Microsoft Access, SQL Server and Excel, which maintain the connection to refresh data dynamically

Yes

Yes

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

Yes

Yes

Conditional formatting

Yes

Yes

Cell styles

Yes

Yes

Table

Yes

Yes

Picture

Yes

Yes

Shapes

Yes

Yes

Chart

Yes*(Supported)

Yes

Sparkline’s

Yes

Yes

Hyperlinks

Yes

Yes

Header & Footer

Yes

Yes

Word art

No

Yes

Themes

No

Yes

Name range

Yes

Yes

Data Sorting

Yes

Yes

Auto Filtering

Yes**

Yes

Grouping & Ungrouping

Yes

Yes

Comments

Yes

Yes

Freeze/ Un Freeze panes

Yes

Yes

Data Validation

Yes

Yes

Equation & Symbols

No

Yes

Number Formats

Yes

Yes

Format Cells (Set background and foreground colors, apply borders around cells, adjust data alignment and set fonts with attributes)

Yes

Yes

Merge / Unmerge Cells

Yes

Yes

Move Worksheets

Yes

Yes

Advanced Features

Template Markers

Yes

No

Document Properties Settings

Yes

Yes

Protect / Unprotect Worksheets

Yes

Yes

Create Subtotals

Yes

Yes

Manage Ole Objects

Yes

Yes

Form Controls and Drawing Shapes

Yes

Yes

Pivot Tables

Yes

Yes

Pivot Chart

Yes

Yes

Addin, VBA, Macros

Yes*** (Preserve Macros & VBA)

Yes

Manipulate Named Ranges

Yes

Yes

Page Setup API

Yes

Yes

Find & Replace API

Yes

Yes

Custom Chart API

Yes

Yes

Formula Calculation Engine

Yes

Yes

Formula

Yes (Reference)

Yes

Pivot Chart

Yes

Yes

Formula auditing

Yes (Only Ignore error)

Yes

Track changes

No

Yes