Back to Devexpress

Spreadsheet Document API Structure

officefileapi-118587-spreadsheet-document-api-product-structure.md

latest5.2 KB
Original Source

Spreadsheet Document API Structure

  • Apr 15, 2025
  • 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.

|

See Also

Spreadsheet Document API Examples