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.
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 |
|
Pictures |
|
|
|
Pivot Charts |
|
|
|
Pivot Tables |
|
|
|
Simple Notes |
|
|
|
Shapes |
|
|
|
Slicers |
|
|
|
Smart Art |
|
|
|
Sparklines |
|
|
|
Tables |
|
|
|
Text Boxes |
|
|
|
Threaded Comments |
|
|
|
Word Art |
|
|
|
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 |
|
N/A |
|
Chart Elements
Feature |
Import, Export |
Print, Export to PDF |
Manage in Code |
Axis Titles |
|
|
|
Chart Axes |
|
|
|
Chart Legends |
|
|
|
Chart Titles |
|
|
|
Chart Templates |
|
|
|
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 |
|
|
|
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) |
|
|
|