Class | Description | |
---|---|---|
Implements addition of items to a collection. |
||
Represents a comment of a cell within a worksheet. |
||
Represents autofiltering inside a worksheet. |
||
Contains the arguments passed to mouse-related events. |
||
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. |
||
Defines the presentation of cell annotations in the WorkbookView control. |
||
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. |
||
Defines the presentation of column headers in the WorkbookView control. |
||
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. |
||
Defines the presentation of the are in the top-left corner of the WorkbookView control. |
||
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. |
||
Represents a drawing within a worksheet. A drawing can contain unlimited number of visual elements such as pictures, diagrams and charts. |
||
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). |
||
Emulates GDI+ hatch brushes using the WPF ImageBrush class. |
||
Defines the presentation of headers in the WorkbookView control. |
||
Represents a hyperlink associated with a worksheet cell. |
||
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. |
||
Defines the presentation of interactive objects in the WorkbookView control. |
||
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. |
||
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. |
||
Provides data for the CollectionChanged event. |
||
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. |
||
Represents a strongly-typed collection that provides notifications when items get added, removed, or when the whole list is refreshed. |
||
Contains the arguments passed to the RowOutlineLevelToggled and ColumnOutlineLevelToggled event handlers. |
||
Provides properties that allow customization of various aspects of printing and print-preview. |
||
Exports worksheets to Adobe Portable Document Format (PDF) files. |
||
Represents a picture in a drawing within a worksheet. |
||
Defines the presentation of pictures in the WorkbookView control. |
||
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. |
||
Defines the presentation of row headers in the WorkbookView control. |
||
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 mouse events. |
||
Contains the arguments passed to Worksheet-related validation events. |
||
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. |
||
Notifies listeners of dynamic changes, such as when items get added and removed or the whole list is refreshed. |
||
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. |
||
Represents hatch patterns corresponding to GDI+ HatchBrush objects. |
||
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. |
||
Describes the action that caused a CollectionChanged event. |
||
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 action to perform when data validation fails. |
||
Specifies the type of data validation. |
||
Specifies the vertical alignment of an element. |