Skip to main content
All docs
V24.2

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 green tick green tick green tick
Chart Sheets green tick green tick green tick

Worksheet Elements and Parts

Feature Import, Export Print, Export to PDF Manage in Code
ActiveX Controls green tick red x red x
Charts green tick green tick green tick
Custom XML Parts green tick N/A green tick
Defined Names green tick green tick green tick
Document Properties green tick green tick green tick
Form Controls green tick green tick green tick
Freeze Panes green tick green tick green tick
Headers/Footers green tick green tick green tick
Hyperlinks green tick green tick green tick
Macros green tick N/A red x
Pictures green tick green tick green tick
Pivot Charts green tick green tick[1] red x
Pivot Tables green tick green tick green tick
Simple Notes green tick green tick green tick
Shapes green tick green tick green tick
Slicers green tick red x red x
Smart Art green tick red x red x
Sparklines green tick green tick green tick
Tables green tick green tick green tick
Text Boxes green tick green tick green tick
Threaded Comments green tick red x green tick
Word Art green tick green tick green tick

Formulas and Functions

Feature Import, Export Print, Export to PDF Manage in Code
Array Formulas green tick N/A green tick
Built-In Functions green tick N/A green tick
Dynamic Arrays green tick N/A green tick
Nested Functions green tick N/A green tick
Shared Formulas green tick N/A green tick
Tracing Precedents/Dependents green tick N/A green tick
User-Defined Formulas green tick[2] N/A green tick

Chart Elements

Feature Import, Export Print, Export to PDF Manage in Code
Axis Titles green tick green tick green tick
Chart Axes green tick green tick green tick
Chart Legends green tick green tick green tick
Chart Titles green tick green tick green tick
Chart Templates green tick[3] green tick green tick
Data Labels green tick green tick green tick
Data Points / Custom Data Points green tick green tick green tick
Data Series green tick green tick green tick
Data Table green tick green tick green tick
Error Bars green tick green tick green tick
Gridlines green tick green tick green tick
Trendlines green tick green tick green tick

Data Shaping Features

Feature Import, Export Print, Export to PDF Manage in Code
Filter Data green tick green tick green tick
Outlines (Grouping) green tick green tick green tick
Sort Data green tick green tick green tick
Validate Data green tick green tick green tick
Workbook/Worksheet Protection green tick green tick green tick

Formatting Features

Feature Import, Export Print, Export to PDF Manage in Code
Cell Styles green tick green tick green tick
Chart Styles green tick green tick green tick
Conditional Formatting green tick green tick green tick
Format Cells green tick green tick green tick
Page Setup Settings green tick green tick green tick
Print Titles green tick green tick green tick
Rich Text Cell Formatting green tick green tick green tick
Table Styles green tick green tick green tick
Themes (Fonts and Colors) green tick green tick green tick
Footnotes
  1. Pivot charts are rendered and printed as regular charts.

  2. Add a custom function to the CustomFunctionCollection collection before you load a document to successfully import this function.

  3. Export is not supported.