Spreadsheet Document API Structure

• Sep 19, 2023
• 2 minutes to read

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. A cell can contain worksheet data, a formula, and formatting.
CellRange	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.
RichTextString	Rich formatted text in a cell.
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.
Shape	A common class for drawing objects in a worksheet.
Picture	An embedded image in a worksheet.
Chart	An embedded chart in a worksheet.
Sparkline	A sparkline within a cell.
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.