We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Feature comparison of Interop and XlsIO

This below table gives you the feature comparison summary between Excel interop and XlsIO library.

 

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

 

Note:

*Chart – Supported chart types in XlsIO are listed here.

**Filters - Currently advanced filters, filter by colors and icons are not supported.

***Macros - If an input document contains Macros or VBA, XlsIO retains them while resaving the document as it is in input document. (Does not have creation and manipulation support).

Article ID: Published Date: Last Revised Date: Platform: Control:
6925 06/08/2016 06/08/2016 WinForms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon