Overview of the Spreadsheet Document API Features

• May 24, 2024
• 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.

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

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	[1]	N/A

Chart Elements

Feature	Import, Export	Print, Export to PDF	Manage in Code
Axis Titles
Chart Axes
Chart Legends
Chart Titles
Chart Templates	[2]
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

1. You need to add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.

2. Export is not supported.