Spreadsheet Examples
- 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
Group
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
Mail Merge
Document Properties
WPF Cell Templates
- How to: Customize Cell Appearance Using WPF Templates
- How to: Customize Cell Appearance Based on a Condition
Commands
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