The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

Product Structure

  • 2 min 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 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.

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