Excel Export and Spreadsheet Document API Feature Comparison
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.
Supported Document Formats
| Document Format | Spreadsheet Document API | Excel Export Library |
|---|---|---|
| XLSX |  |
|
| XLS | |
|
| CSV | |
|
| XLSM | |
 |
| 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 | |
|
| 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 | |
|
* Available for the entire worksheet data range, not a specific cell range.