Examples
- 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
Data Binding
- 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
- 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: 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
- 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
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 an Embedded 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: 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
Customization
Feedback