Back to Devexpress

Excel Export and Spreadsheet Document API Feature Comparison

officefileapi-114211-excel-export-library-overview-excel-export-and-spreadsheet-document-api-feature-comparison.md

latest5.7 KB
Original Source

Excel Export and Spreadsheet Document API Feature Comparison

  • Mar 05, 2024

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 FormatSpreadsheet Document APIExcel Export Library
XLSX
XLS
CSV
XLSM
XLSB
XLTX/XLTM/XLT
TXT (Tab Delimited Text)

Document Generation Capabilities

FeatureSpreadsheet Document APIExcel 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[1]
Protection
Encryption
Document properties

Footnotes

  1. Available for the entire worksheet data range, not a specific cell range.