Examples
- 5 minutes to read
This section provides a full list of examples (grouped by features) contained in this help.
Important
The Universal Subscription or an additional Document Server Subscription is required to use this example in production code. Please refer to the DevExpress Subscription page for pricing information.
File Operations
- 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
Workbooks
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 within a Workbook
- How to: Copy Worksheets between Workbooks
- 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
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
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 Comment 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
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
Import and Export Data
Formatting
- How to: Apply a Style to a Cell or Range of Cells
- How to: Create or Modify a Style
- How to: Format a Cell or Range of Cells
- 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: 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
Tables
- How to: Create a Table
- How to: Perform Calculations in a Table
- How to: Apply a Table Style
- How to: Create, Modify And Delete Table Styles
Sort Data
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
Charts
- How to: Create a Basic Chart
- How to: Format Chart Elements
- How to: Display the Chart Title
- How to: Display and Format Data Label
- How to: Show or Hide the Chart Legend
- How to: Change the Display of Chart Axes
- How to: Protect a Chart
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: 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
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