Spreadsheet Document API Examples

• Feb 26, 2026
• 7 minutes to read

Important

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these examples in production code.

Workbooks

• How to: Create a New Workbook
• How to: Load a Document to a Workbook
• How to: Save a Document to a File
• How to: Export a Workbook to PDF
• How to: Export a Document to HTML
• How to: Implement Progress Notifications for Workbook Operations
• How to: Clone a Workbook
• How to: Merge Multiple Workbooks Into One Document
• How to: Specify Document Properties
• How to: Load Document Properties

Worksheets

• How to: Access a Worksheet
• How to: Set an Active Worksheet
• How to: Add a New Worksheet
• How to: Delete a Worksheet
• How to: Rename a Worksheet
• How to: Copy Worksheets
• How to: Move a Worksheet to another Location
• How to: Show and Hide a Worksheet
• How to: Show and Hide Gridlines
• How to: Set Page Orientation
• How to: Set Page Margins
• How to: Set Paper Size
• How to: Zoom In and Out of a Worksheet
• How to: Generate a Thumbnail Image from a Worksheet

Rows and Columns

• How to: Access a Row or Column
• How to: Add a New Row or Column to a Worksheet
• How to: Delete a Row or Column from a Worksheet
• How to: Copy a Row or Column
• How to: Hide a Row or a Column
• How to: Specify Row Height or Column Width
• How to: Freeze and Unfreeze Rows and Columns

Cells

• How to: Access a Cell in a Worksheet
• How to: Access a Range of Cells
• How to: Insert a Cell or Cell Range
• How to: Delete a Cell or Range of Cells
• How to: Create a Named Range of Cells
• How to: Change a Cell or Cell Range Value
• How to: Add Formulas to Cells
• How to: Add a Hyperlink to a Cell
• How to: Add a Simple Note To a Cell
• How to: Clear Cells of Content, Formatting, Hyperlinks and Comments
• How to: Copy Cell Data Only, Cell Style Only, or Cell Data with Style
• How to: Merge Cells or Split Merged Cells
• How to: Save a Cell Range as an Image

Formulas

• How to: Use Constants and Calculation Operators in Formulas
• How to: Use Cell and Worksheet References in Formulas
• How to: Use Names in Formulas
• How to: Create Named Formulas
• How to: Use Functions and Nested Functions in Formulas
• How to: Create Shared Formulas
• How to: Create Array Formulas

Bind to Data

• How to: Use Worksheet Table as a Data Source
• How to: Use Worksheet Data Bindings to Log and Process Data

Import and Export Data

• How to: Import Data to a Worksheet
• How to: Export a Worksheet Range to a DataTable
• How to: Create Thumbnail Images for Excel, Word, and PDF Documents

Formatting

• How to: Apply or Modify a Workbook Theme
• How to: Apply a Style to a Cell or Range of Cells
• How to: Create or Modify a Cell Style
• How to: Format a Cell or Range of Cells
• How to: Apply Rich Formatting to Cell Text
• How to: Specify Number or Date Format for Cell Content
• How to: Change Cell Font and Background Color
• How to: Configure Cell Font Settings
• How to: Load and Use Custom Fonts
• How to: Align Cell Content
• How to: Add and Remove Cell Borders
• How to: Clear Cell Formatting

Conditional Formatting

• How to: Format Cell Values that are Above or Below the Average
• How to: Format Cells that are Between or Not Between Two Values
• How to: Format Top or Bottom Ranked Values
• How to: Format Cells based on the Text in the Cell
• How to: Format Unique or Duplicate Values, Blank Cells and Formula Errors
• How to: Format Cells that Contain Dates
• How to: Format Cells that are Less than, Greater than or Equal to a Value
• How to: Use a Formula to Determine which Cells to Format
• How to: Format Cells Using a Two-Color Scale
• How to: Format Cells Using a Three-Color Scale
• How to: Format Cells Using Data Bars
• How to: Format Cells Using Icon Sets

Sort Data

• How to: Sort Data in a Worksheet Range

Filter Data

• How to: Enable Filtering
• How to: Filter by Cell Values
• How to: Filter by Date Values
• How to: Apply a Custom Date Filter
• How to: Apply a Custom Text Filter
• How to: Apply a Custom Number Filter
• How to: Apply a Dynamic Filter
• How to: Filter Top or Bottom Ranked Values
• How to: Sort Data in the Filtered Range
• How to: Reapply a Filter
• How to: Clear a Filter

Group Data

• How to: Outline Data Manually
• How to: Outline Data Automatically
• How to: Insert Subtotals in a Data Range

Find and Replace

• How to: Perform Search in a Document

Shapes

• How to: Create a Shape
• How to: Create a Shape Group
• How to: Create a Shape Connector
• How to: Add Text to a Shape
• How to: Change Shape’s Fill and Outline Color
• How to: Remove a Shape

Charts

• How to: Create and Modify a Chart
• How to: Create Excel 2016 Charts
• How to: Create a Stock Chart
• How to: Format Chart Elements
• How to: Change the Appearance of Series Points
• How to: Display the Chart Title
• How to: Display and Format Data Labels
• How to: Show or Hide the Chart Legend
• How to: Change the Display of Chart Axes
• How to: Add a Trendline
• How to: Create a Chart Sheet
• How to: Move a Chart to a Chart Sheet
• How to: Specify Chart Sheet Print Options
• How to: Remove a Chart Sheet
• How to: Protect a Chart Sheet
• How to: Generate a Thumbnail Image from a Chart Sheet

Pivot Tables

• How to: Create a Pivot Table
• How to: Refresh a Pivot Table
• How to: Change a Data Source for a Pivot Table
• How to: Move a Pivot Table
• How to: Clear or Remove a Pivot Table
• How to: Change the PivotTable Layout
• How to: Subtotal Fields in a Pivot Table
• How to: Display or Hide Grand Totals for a Pivot Table
• How to: Format Numbers and Dates in a Pivot Table
• How to: Apply a Predefined Style to a Pivot Table
• How to: Apply a Custom Style to a Pivot Table
• How to: Control Style Options
• How to: Change the Summary Function for a Data Field
• How to: Apply a Custom Calculation to a Data Field
• How to: Create a Calculated Field
• How to: Create a Calculated Item
• How to: Sort Items in a Pivot Table
• How to: Filter Items in a Pivot Table
• How to: Group Items in a Pivot Table

Mail Merge

• Mail Merge Overview
• Template Document
• Mail Merge Functions

Sparklines

• How to: Create Sparklines
• How to: Group and Ungroup Sparklines
• How to: Customize the Sparkline Appearance
• How to: Specify Sparkline Axis Settings
• How to: Delete Sparklines

Pictures

• How to: Insert and Delete Pictures
• How to: Modify a Picture
• How to: Replace a Worksheet Picture
• How to: Add a Hyperlink to a Picture

Protection

• How to: Protect a Workbook
• How to: Protect a Worksheet
• How to: Protect Specific Worksheet Ranges
• How to: Open and Save Password-Encrypted Files
• How to: Write-Protect a Workbook

Printing

• How to: Print a Workbook
• How to: Specify Print Settings
• How to: Show a Print Preview Form for a Workbook
• How to: Add Headers and Footers to a Worksheet Printout
• How to: Define a Print Area
• How to: Insert Page Breaks in a Worksheet
• How to: Print Titles on a Worksheet