This topic provides information on feature differences between the Excel Export Library and Spreadsheet Document API, so you can select the product that fully meets your demands.
Document Format |
Spreadsheet Document API |
Excel Export Library |
XLSX |
 |
 |
XLS |
 |
 |
CSV |
 |
 |
XLSM |
 |
 |
XLSB |
 |
 |
XLTX/XLTM/XLT |
 |
 |
TXT (Tab Delimited Text) |
 |
 |
Document Generation Capabilities
Feature |
Spreadsheet Document API |
Excel Export Library |
Workbook/Worksheet |
 |
 |
Rows/Columns |
 |
 |
Cells |
 |
 |
Merged cells |
 |
 |
Formulas |
 |
 |
Calculation engine |
 |
 |
Custom functions |
 |
 |
Defined names |
 |
 |
External links |
 |
 |
Cell styles |
 |
 |
Cell formatting |
 |
 |
Conditional formatting |
 |
 |
.NET number formats |
 |
 |
Theme colors |
 |
 |
Pictures |
 |
 |
Shapes |
 |
 |
Charts |
 |
 |
Comments |
 |
 |
Sparklines |
 |
 |
Hyperlinks |
 |
 |
Tables |
 |
 |
Pivot Tables |
 |
 |
Filtering |
 |
 |
Grouping/Outline |
 |
 |
Data validation |
 |
 |
Frozen panes |
 |
 |
Page breaks/ Page setup |
 |
 |
Print area/options/titles |
 |
 |
Headers/footers |
 |
 |
Error checking options |
 |
 |
Protection |
 |
 |
Encryption |
 |
 |
Document properties |
 |
 |