Class | Description | |
---|---|---|
![]() |
Implements addition of items to a collection. |
|
![]() |
Represents a comment of a cell within a worksheet. |
|
![]() |
Represents autofiltering inside a worksheet. |
|
![]() |
Contains methods that help serializing and deserializing complex objects to and from binary streams. |
|
![]() |
CalcExporter lets you export Workbook objects to OpenOffice Calc spreadsheets. |
|
![]() |
CalcImporter lets you import OpenOffice Calc spreadsheets into a Workbook. |
|
![]() |
Identifies a single cell in a Worksheet. |
|
![]() |
Represents the interactive object containing a comment for a cell within a worksheet. |
|
![]() |
Provides data for the CellChanged event. |
|
![]() |
Represents a specialized collection for worksheet cells. |
|
![]() |
Represents a copy of the cell data in a worksheet region. Instances of this class can be obtained by calling the CopyData method of a Worksheet. |
|
![]() |
Provides data for events related to individual cells. |
|
![]() |
An immutable representation of a cell reference. |
|
![]() |
Contains the arguments passed to cell-related mouse events. |
|
![]() |
Identifies a range of cells in a Worksheet. |
|
![]() |
Represents a specialized collection for cell ranges. |
|
![]() |
Provides data for validation events related to individual cells. |
|
![]() |
Represents a command that can track and undo changes of a Worksheet. |
|
![]() |
Identifies a column in a worksheet. |
|
![]() |
Provides data for the ColumnChanged event. |
|
![]() |
Represents a specialized collection for worksheet columns. |
|
![]() |
Contains the arguments passed to column-related events. |
|
![]() |
Contains the arguments passed to column-related mouse events. |
|
![]() |
Identifies a range of columns in a Worksheet. |
|
![]() |
Contains the arguments passed to events related to multiple column. |
|
![]() |
Contains the arguments passed to validation events related to multiple columns. |
|
![]() |
Contains the arguments passed to validation events related to multiple columns. |
|
![]() |
Represents an action that modifies the workbook and whose effects can be undone. |
|
![]() |
Represents a set of Command instances as a single operation. Undoing or redoing the composite action, respectively undoes or redoes all its constituent subactions at the same time. |
|
![]() |
Provides capabilities to convert various types to and from strings in a culture-independent way. |
|
![]() |
CsvExporter lets you export Worksheet data into .csv file. |
|
![]() |
CsvImporter lets you import .csv files into a Worksheet. |
|
![]() |
Represents a currency ISO code to locale relationship. |
|
![]() |
Represents a helper class containing the definitions of currency ISO codes to locale relationships. |
|
![]() |
Contains predefined format strings for different numeric formats. |
|
![]() |
Represents a command that implements the IDisposable interface. |
|
![]() |
Provides data for the DrawColumn event. |
|
![]() |
Represents a drawing within a worksheet. A drawing can contain unlimited number of visual elements such as pictures, diagrams and charts. |
|
![]() |
Provides data for the DrawRow event. |
|
![]() |
ExcelExporter lets you export Workbook objects to Excel Open XML documents. |
|
![]() |
ExcelImporter lets you import Excel Open XML documents into a Workbook. |
|
![]() |
Represents a filter for a single column. |
|
![]() |
Represents a sequence of text fragments with different formatting (font, size, color). |
|
![]() |
HtmlExporter lets you export Workbook objects to HTML files. |
|
![]() |
Represents the base class for HTML exporters. |
|
![]() |
Provides common HTML meta-tag names. |
|
![]() |
Represents a hyperlink associated with a worksheet cell. |
|
![]() |
Exports worksheets as images. |
|
![]() |
Contains the arguments passed to the InplaceEditStarted and InplaceEditEnded event handlers. |
|
![]() |
Contains the arguments passed to the InplaceEditStarting and InplaceEditEnding event handlers. |
|
![]() |
Represents a worksheet object that can be modified interactively by the user. |
|
![]() |
Represents amounts of specific units. |
|
![]() |
Specifies units of measure. |
|
![]() |
Represents a specialized collection for merged cells in a worksheet, each merged cell is represented by a CellRange object. |
|
![]() |
HtmlExporter lets you export Workbook objects to MHTML files. |
|
![]() |
Implements moving of items within a collection. |
|
![]() |
Represents a collection of objects that can be manipulated by name. The objects in the collection are required to have unique names. |
|
![]() |
Represents a named range of cells. |
|
![]() |
Represents a specialized collection of NamedRange objects. |
|
![]() |
Represents a numeric format within a workbook. |
|
![]() |
Provides data for events related to interactive objects. |
|
![]() |
Provides data for events related to interactive objects. |
|
![]() |
Contains the arguments passed to handlers of object validation events. |
|
![]() |
Contains the arguments passed to object-related mouse events. |
|
![]() |
Contains the arguments passed to handlers of object validation events. |
|
![]() |
Contains the arguments passed to the RowOutlineLevelToggled and ColumnOutlineLevelToggled event handlers. |
|
![]() |
Exports worksheets as PDF files. |
|
![]() |
Represents a picture in a drawing within a worksheet. |
|
![]() |
Provides data for the PropertyValueChanged event. |
|
![]() |
Implements deletion of items from a collection. |
|
![]() |
Implements replacement of items in a collection. |
|
![]() |
Implements clearing of a collection. |
|
![]() |
Identifies a row in a worksheet. |
|
![]() |
Provides data for the RowChanged event. |
|
![]() |
Represents a specialized collection for worksheet rows. |
|
![]() |
Contains the arguments passed to row-related events. |
|
![]() |
Contains the arguments passed to row-related mouse events. |
|
![]() |
Identifies a range of rows in a Worksheet. |
|
![]() |
Contains the arguments passed to events related to multiple rows. |
|
![]() |
Contains the arguments passed to validation events related to multiple rows. |
|
![]() |
Contains the arguments passed to validation events related to multiple rows. |
|
![]() |
Represents a fragment of text with uniform formatting in a FormattedText object. |
|
![]() |
Represents a set of selected cells and objects within a grid view. |
|
![]() |
Provides data for the SerializeColumnTag and DeserializeColumnTag event handlers. |
|
![]() |
Provides data for the SerializeData and DeserializeData event handlers. |
|
![]() |
Provides data for the SerializeRowTag and DeserializeRowTag event handlers. |
|
![]() |
Provides data for the SerializeTag and DeserializeTag event handlers. |
|
![]() |
Represents a key in a sorting operation. |
|
![]() |
Specifies the order of a sorting operation, ascending or descending. |
|
![]() |
Represents a copy of the cell styles in a worksheet region. Instances of this class can be obtained by calling the CopyStyles method of a Worksheet. |
|
![]() |
Represents a command that can track and undo changes of INotifyPropertyValueChanged objects. |
|
![]() |
Represents a strongly-typed collection that supports undo and redo. |
|
![]() |
Contains the arguments passed to the ActionUndone and ActionRedone event handlers. |
|
![]() |
Provides data for the ValidationFailed event. |
|
![]() |
The main document class, contains a collection of worksheets, named ranges and other related objects. |
|
![]() |
Provides print and print preview for Workbook objects. |
|
![]() |
Represents a control that can display Workbook objects. |
|
![]() |
Represents a worksheet in a workbook, that is, a rectangular grid of cells containing data. |
|
![]() |
Provides data for the WorksheetChanged event. |
|
![]() |
Represents a specialized collection of Worksheet objects. |
|
![]() |
Contains the arguments passed to Worksheet-related events. |
|
![]() |
Contains the arguments passed to Worksheet-related mouse events. |
|
![]() |
Contains the arguments passed to Worksheet-related validation events. |
|
![]() |
Represents a control that can display individual Worksheet objects. |
|
![]() |
Contains methods that help serializing and deserializing complex objects to and from XML documents. |
Interface | Description | |
---|---|---|
![]() |
Represents the style of a column. |
|
![]() |
Represents conditional format associated with a range of cells. |
|
![]() |
Represents a collection of IConditionalFormat objects. |
|
![]() |
Defines a name for the type that implements this interface. |
|
![]() |
Represents an inplace-editable object within a worksheet. |
|
![]() |
Provides notification for property changes. |
|
![]() |
Represents the style of a row. |
|
![]() |
Represents the style of an element. |
|
![]() |
Represents data validation associated with a range of cells. |
Enumeration | Description | |
---|---|---|
![]() |
Identifies the distinct selection handles of an interactive object. |
|
![]() |
Indicates an autofiltering operator. |
|
![]() |
Specifies an operator for value comparison. |
|
![]() |
Specifies the type of a conditional format. |
|
![]() |
Specifies what mouse cursor to display while a user interacts with the view controls. |
|
![]() |
Specifies the type of a dynamic autofilter. |
|
![]() |
Specifies the date component to increment when filling dates. |
|
![]() |
Specifies the direction of a data fill operation. |
|
![]() |
Specifies the method used to fill series of cells. |
|
![]() |
Specifies the target of find and replace operations. |
|
![]() |
Specifies the horizontal alignment of an element. |
|
![]() |
Specifies the type of a hyperlink. |
|
![]() |
Specifies whether a find operation should search in cell formulas or values. |
|
![]() |
Specifies the anchor of a worksheet object. |
|
![]() |
Specifies the anchor position of a worksheet object. |
|
![]() |
Specifies the order of printed pages. |
|
![]() |
Specifies how the existing cells are moved when inserting new cells in a CellRange object. |
|
![]() |
Specifies the direction of find and replace operations. |
|
![]() |
Specifies the order of find and replace operations. |
|
![]() |
Specifies how the cells are moved when removing cells from a CellRange object. |
|
![]() |
Specifies the direction of a sorting operation. |
|
![]() |
Specifies the order of a sorting operation, ascending or descending. |
|
![]() |
Specifies the alignment of the tabs in a WorkbookView. |
|
![]() |
Specifies the action to perform when data validation fails. |
|
![]() |
Specifies the type of data validation. |
|
![]() |
Specifies the vertical alignment of an element. |