[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Spreadsheet Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
   Charting
  [Expand]Mail Merge
  [Expand]Examples
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Product Structure

Use the following links to access reference information about the most important classes and interfaces of the Spreadsheet Document API.

Class/Interface Description
Workbook The root object of the non-visual spreadsheet engine that allows you to create, load, edit, save and print spreadsheet documents.
To use this object in production code, you would need to acquire a license for the DevExpress Office File API or DevExpress Universal Subscription.
Worksheet An individual worksheet in a workbook.
Row An individual row in a worksheet.
Column An individual column in a worksheet.
Cell A box at the intersection of a column and a row in a worksheet that can contain worksheet data, a formula and formatting.
Range The base interface that provides the functionality required to work with a worksheet cell and a range of cells.
CellValue A data value contained in a cell.
Formatting An interface containing options to change cell format settings: fill, font, alignment, borders, and number format.
ConditionalFormatting The base interface for conditional formatting rules.
DefinedName A name that refers to a cell, cell range, formula, or constant value.
WorkbookFunctions An interface that provides access to the built-in worksheet functions divided into categories by their functionality and allows you to override a specific function.
ICustomFunction An interface that provides basic properties and methods required to implement a custom worksheet function.
FormulaEngine Provides the capability to calculate and parse worksheet formulas. See Formula Engine.
Hyperlink A hyperlink associated with a cell or cell range.
Comment A comment attached to a worksheet cell.
Picture An embedded image in a worksheet.
Chart An embedded chart in a worksheet.
Table A table in a worksheet.
PivotTable A PivotTable report in a worksheet.
WorksheetDataBinding An interface containing information about a cell range bound to an external data source or used to create a data source.

Expanded See Also

Is this topic helpful?​​​​​​​