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 |
|
|