Overview of the Spreadsheet Document API Features
- 2 minutes to read
Spreadsheet Document API is a feature-rich component. This article lists available workbook elements and workbook-related settings, and on which levels the Spreadsheet Document API supports them.
Features that are not supported are excluded from this list.
Please refer to the following topic for information on supported file formats: Supported Formats.
Workbook Parts
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Worksheets |  |
|
|
| Chart Sheets | |
|
|
Worksheet Elements and Parts
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| ActiveX Controls | |
 |
|
| Charts | |
|
|
| Custom XML Parts | |
N/A | |
| Defined Names | |
|
|
| Document Properties | |
|
|
| Form Controls | |
|
|
| Freeze Panes | |
|
|
| Headers/Footers | |
|
|
| Hyperlinks | |
|
|
| Macros | |
N/A | |
| OLE Objects | |
|
|
| Pictures | |
|
|
| Pivot Charts | |
[1] |
|
| Pivot Tables | |
|
|
| Simple Notes | |
|
|
| Shapes | |
|
|
| Slicers | |
|
|
| Smart Art | |
|
|
| Sparklines | |
|
|
| Tables | |
|
|
| Text Boxes | |
|
|
| Threaded Comments | |
|
|
| Word Art[2] | |
|
|
Formulas and Functions
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Array Formulas | |
N/A | |
| Built-In Functions | |
N/A | |
| Dynamic Arrays | |
N/A | |
| Nested Functions | |
N/A | |
| Shared Formulas | |
N/A | |
| Tracing Precedents/Dependents | |
N/A | |
| User-Defined Formulas | [3] |
N/A | |
Chart Elements
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Axis Titles | |
|
|
| Chart Axes | |
|
|
| Chart Legends | |
|
|
| Chart Titles | |
|
|
| Chart Templates | [4] |
|
|
| Data Labels | |
|
|
| Data Points / Custom Data Points | |
|
|
| Data Series | |
|
|
| Data Table | |
|
|
| Error Bars | |
|
|
| Gridlines | |
|
|
| Trendlines | |
|
|
Data Shaping Features
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Filter Data | |
|
|
| Outlines (Grouping) | |
|
|
| Sort Data | |
|
|
| Validate Data | |
|
|
| Workbook/Worksheet Protection | |
|
|
Formatting Features
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Cell Styles | |
|
|
| Chart Styles | |
|
|
| Conditional Formatting | |
|
|
| Format Cells | |
|
|
| Page Setup Settings | |
|
|
| Print Titles | |
|
|
| Rich Text Cell Formatting | |
|
|
| Table Styles | |
|
|
| Themes (Fonts and Colors) | |
|
|
Footnotes
-
Pivot charts are rendered and printed as regular charts.
-
Limited support: some properties are not supported in binary (XLS and other) formats.
-
Add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.
-
Export is not supported.