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/Unfreeze panes | Yes | Yes |
Data Validation | Yes | Yes |
Equations & 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 |
*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 the input document. (does not have creation and manipulation support).