Spreadsheet Document API Examples
- 6 minutes to read
Important
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these examples in production code.
Workbooks
- How to: Create a New Workbook
- 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
- How to: Clone a Workbook
- How to: Merge Multiple Workbooks Into One Document
- How to: Specify Document Properties
- How to: Load Document Properties
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: 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: 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: 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
Shapes
- How to: Create a Shape
- How to: Create a Shape Group
- How to: Create a Shape Connector
- How to: Add Text to a Shape
- How to: Change Shape’s Fill and Outline Color
- How to: Remove a Shape
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 Appearance 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
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: 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
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
Pictures
- How to: Insert and Delete Pictures
- How to: Modify an Embedded Picture
- How to: Add a Hyperlink to a Picture
Protection
- How to: Protect a Workbook
- How to: Protect a Worksheet
- How to: Protect Specific Worksheet Ranges
- How to: Open and Save Password-Encrypted Files
- How to: Write-Protect a Workbook
Printing
- How to: Print a Workbook
- How to: Specify Print Settings
- How to: Show a Print Preview Form for a Workbook
- 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
- How to: Use the WPF Chart Rendering Mechanism When Printing or Exporting a Workbook to PDF