Spreadsheet Examples

• Apr 15, 2025
• 7 minutes to read

The section contains the following examples:

File Operations

• How to: Load a Document into SpreadsheetControl
• How to: Save a Document to a File
• How to: Export a Workbook to PDF
• How to: Export a Document to HTML

Workbooks

• How to: Create a New Workbook
• How to: Access a Workbook
• How to: Clone a Workbook
• How to: Specify Document Properties
• How to: Merge Multiple Workbooks Into One Document

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: Show and Hide Row and Column Headers
• How to: Zoom In and Out of 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: Show or Hide a Row or Column
• How to: Freeze and Unfreeze Rows and Columns
• How to: Specify Row Height or Column Width
• How to: Restrict the Number of Visible Rows and Columns in a Worksheet

Cells and Ranges

• How to: Access a Cell in a Worksheet
• How to: Access a Range of Cells
• How to: Obtain Selected Range and Active Cell
• 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: Create, Edit and Copy Cell Comments
• 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

Formulas

• How to: Create Formulas Using Cell References
• How to: Create Formulas Using Cell Names
• How to: Create Named Formulas
• How to: Create Formulas Using Functions
• How to: Create Array Formulas
• How to: Create Shared Formulas
• How to: Create Custom Functions
• How to: Create a Custom Function that Returns an Array

Bind to Data

• How to: Bind a Spreadsheet to an MS SQL Server Database (Part 1)
• How to: Bind a Spreadsheet to an MS SQL Server Database (Part 2)
• How to: Bind a Data Grid to a Cell Range
• How to Bind a Spreadsheet to a List of Objects

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: Load and Use Custom Fonts
• 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: Apply Gradient Fill
• 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

Group Data

• How to: Outline Data Manually
• How to: Outline Data Automatically
• How to: Insert Subtotals in a Data 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

Pivot Tables

Basic Actions

• 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

Layout and Format

• How to: Subtotal Fields in a Pivot Table
• How to: Display or Hide Grand Totals for a Pivot Table
• How to: Change the PivotTable Layout
• 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

Custom Calculations

• 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

Sort and Filter

• How to: Sort Items in a Pivot Table
• How to: Filter Items in a Pivot Table

Group

• How to: Group Items in a Pivot Table

Printing

• How to: Print a Workbook
• How to: Specify Print Settings
• How to: Show a Print Preview Form for a Document
• 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

Shapes

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

Pictures

• How to: Insert and Delete Pictures
• How to: Modify Embedded Picture
• How to: Replace a Worksheet Picture
• How to: Add a Hyperlink to a Picture
• How to: Place a Picture in a Cell

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 Color 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 to a Chart
• How to: Protect a Chart
• 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

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

Protection

• How to: Protect a Workbook
• How to: Protect a Worksheet
• How to: Protect Specific Worksheet Ranges

Mail Merge

• How to: Perform a Mail Merge

Document Properties

• How to: Specify Document Properties

WPF Cell Templates

• How to: Customize Cell Appearance Using WPF Templates
• How to: Customize Cell Appearance Based on a Condition

Commands

• How to: Replace Built-In Command with a Custom Command

Customization

• How to: Customize the Integrated Ribbon UI for the Spreadsheet
• How to: Create a Custom Progress Indicator for the Spreadsheet
• How to: Replace Built-In Command with a Custom Command
• How to: Customize the Spreadsheet Context Menus
• How to: Save and Restore Custom Cell Editors
• How to: Customize Column and Row Headings
• How to: Create a Data Entry Form