WinForms Spreadsheet Control Examples

• May 27, 2025
• 7 minutes to read

This section provides a list of examples (grouped by features) contained in this help.

File Operations

• How to: Load a Document into SpreadsheetControl
• How to: Save a Document to a File
• How to: Store a Workbook in the Database
• How to: Export a Workbook to PDF
• How to: Export a Document to HTML

Workbooks

• How to: Access a Workbook
• How to: Create a New Workbook
• How to: Update External References in the Loaded 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 in a Workbook
• How to: Show and Hide a Worksheet
• How to: Show and Hide Gridlines
• How to: Show and Hide Row and Column Headings
• 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

• 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: Convert Objects to Cell Values and Cell Values to Objects
• 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: 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
• How to: Create a Simple Custom Function
• How to: Use Excel Add-Ins in the Spreadsheet Control

Import and Export Data

• How to: Import Data to a Worksheet
• How to: Export a Worksheet Range to a DataTable
• How to: Use a Custom Converter for Export to a DataTable

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

Mail Merge

• How to: Perform a Mail Merge
• How to: Create a Master-Detail Report
• How to: Sort Data
• How to: Group Data
• How to: Filter Data
• How to: Create a Master-Detail Report Without Coding

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: Apply Gradient Fill
• 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
• How to: Apply Conditional Formatting to a Complex Range

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

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

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 Formatting

• 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

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

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 Error Bars to a Chart Series
• 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
• How to: Open and Save a Password Encrypted File

Commands

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

Customization

• How to: Use Custom Draw Events to Customize the Appearance of Spreadsheet Elements
• How to: Customize or Hide the Popup Menu
• How to: Replace Built-In Command with a Custom Command
• How to: Use Custom Cell Editors
• How to: Save and Restore Custom Cell Editors
• How to: Create a Custom Progress Indicator for the Spreadsheet Control
• How to: Create a Data Entry Form
• How to: Edit Rich Text