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 DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
XLS DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
CSV DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
XLSM DocumentExportCapability_GreenTick DocumentExportCapability_RedX
XLSB DocumentExportCapability_GreenTick DocumentExportCapability_RedX
XLTX/XLTM/XLT DocumentExportCapability_GreenTick DocumentExportCapability_RedX
TXT (Tab Delimited Text) DocumentExportCapability_GreenTick DocumentExportCapability_RedX

Document Generation Capabilities

Feature Spreadsheet Document API Excel Export Library
Workbook/Worksheet DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Rows/Columns DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Cells DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Merged cells DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Formulas DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Calculation engine DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Custom functions DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Defined names DocumentExportCapability_GreenTick DocumentExportCapability_RedX
External links DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Cell styles DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Cell formatting DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Conditional formatting DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
.NET number formats DocumentExportCapability_RedX DocumentExportCapability_GreenTick
Theme colors DocumentExportCapability_RedX DocumentExportCapability_GreenTick
Pictures DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Charts DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Comments DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Sparklines DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Hyperlinks DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Tables DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Pivot Tables DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Filtering DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Grouping/Outline DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Data validation DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Frozen panes DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Page breaks/ Page setup DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Print area/options/titles DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Headers/footers DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Error checking options DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick[1]
Protection DocumentExportCapability_GreenTick DocumentExportCapability_RedX
Encryption DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Document properties DocumentExportCapability_GreenTick DocumentExportCapability_GreenTick
Footnotes
  1. Available for the entire worksheet data range, not a specific cell range.