officefileapi-404974-spreadsheet-document-api-feature-overview.md
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.
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Worksheets | |||
| Chart Sheets |
| 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] |
| 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 |
| 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 |
| Feature | Import, Export | Print, Export to PDF | Manage in Code |
|---|---|---|---|
| Filter Data | |||
| Outlines (Grouping) | |||
| Sort Data | |||
| Validate Data | |||
| Workbook/Worksheet Protection |
| 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.