WinForms Spreadsheet Control API
- 2 minutes to read
Use the following links to access reference information about the most important classes and interfaces in the WinForms Spreadsheet control:
Class/Interface | Description |
---|---|
Spreadsheet |
The primary control of the Win |
Spreadsheet |
Displays the active cell’s address and content and is used to view, enter and edit formulas and cell data in the Spreadsheet |
Spreadsheet |
Stores settings specific for the Spreadsheet |
Spreadsheet |
Contains options used to restrict an end-user’s ability to manage a document within the Spreadsheet |
IWorkbook | A document in the Spreadsheet |
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. |
Cell |
The base interface that provides the functionality required to work with a worksheet cell and a range of cells. |
Cell |
A data value contained in a cell. |
Formatting | An interface containing options to change cell format settings: fill, font, alignment, borders, and number format. |
Rich |
Rich formatted text in a cell. |
Conditional |
The base interface for conditional formatting rules. |
Defined |
A name that refers to a cell, cell range, formula, or constant value. |
Workbook |
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. |
ICustom |
An interface that provides basic properties and methods required to implement a custom worksheet function. |
Formula |
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. |
Pivot |
A Pivot |
Worksheet |
An interface containing information about a cell range bound to an external data source or used to create a data source. See Data Binding. |
Custom |
A custom cell in-place editor assigned to a cell or cell range in a worksheet. |
See Also