Class | Description | |
---|---|---|
![]() |
Contains information about the activatingCell event. |
|
![]() |
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 autoFilterChanged event handlers. |
|
![]() |
CalcExporter lets you export Workbooks 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 cell change events. |
|
![]() |
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 Worksheet.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. |
|
![]() |
Provides data to cellParsing event handlers. |
|
![]() |
Identifies a range of cells in a Worksheet. |
|
![]() |
Represents a specialized collection for cell ranges. |
|
![]() |
Provides data to events related to a range of cells. |
|
![]() |
Provides data for events related to multiple cells. |
|
![]() |
Contains the arguments passed to cellsInserted event handlers. |
|
![]() |
Contains the arguments passed to cellsMoved event handlers. |
|
![]() |
Contains the arguments passed to cellsRemoved event handlers. |
|
![]() |
Contains the arguments passed to cellsSorted event handlers. |
|
![]() |
Provides data for events related to individual cells. |
|
![]() |
Provides data for validation events related to individual cells. |
|
![]() |
Represents a command that can track and undo changes of a Worksheet. |
|
![]() |
Provides data for collection change events. |
|
![]() |
Identifies a column in a worksheet. |
|
![]() |
Provides data for the WorksheetListener.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 column-related events. |
|
![]() |
Contains the arguments passed to the WorksheetListener.columnMoved event. |
|
![]() |
Contains the arguments passed to the WorksheetListener.columnsRemoved event. |
|
![]() |
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. |
|
![]() |
Enables exporting CSV files from a Worksheet. |
|
![]() |
Enables importing 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 disposable pattern. |
|
![]() |
Provides data for the ViewListener.drawCell event. |
|
![]() |
Provides data for the ViewListener.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 ViewListener.drawRow event. |
|
![]() |
Contains event information passed to queryDropDown event handlers. |
|
![]() |
Contains event information passed to dropDownValueSelected event handlers. |
|
![]() |
ExcelExporter lets you export Workbooks to Excel Open XML documents. |
|
![]() |
ExcelImporter lets you import Excel Open XML documents into a Workbook. |
|
![]() |
Implement support for serialization of shared images. |
|
![]() |
Represents a filter for a single column. |
|
![]() |
Represents a sequence of text fragments with different formatting (font, size, color). |
|
![]() |
HtmlExporter lets you export Workbooks to HTML files. |
|
![]() |
Represents the base class for HTML exporters. |
|
![]() |
Represents a hyperlink associated with a worksheet cell. |
|
![]() |
Exports worksheets as images. |
|
![]() |
Contains the arguments passed to the ViewListener.inplaceEditStarted and ViewListener.inplaceEditEnded event handlers. |
|
![]() |
Contains the arguments passed to the ViewListener.inplaceEditStarting and ViewListener.inplaceEditEnding event handlers. |
|
![]() |
Represents a worksheet object that can be modified interactively by the user. |
|
![]() |
Contains localized texts for spreadsheet's standard forms. |
|
![]() |
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. |
|
![]() |
Provides common HTML meta-tag names. |
|
![]() |
HtmlExporter lets you export Workbooks 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 information for various property changed events. |
|
![]() |
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 an off-screen painting target. |
|
![]() |
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. |
|
![]() |
Defines the attributes of a printed workbook. Use the PrintOptions object returned by the Workbook.getPrintOptions method to set the attributes of a specific workbook. |
|
![]() |
Implements a print preview window. |
|
![]() |
Implements deletion of items from a collection. |
|
![]() |
CellPainter rendering context. |
|
![]() |
Implements replacement of items in a collection. |
|
![]() |
Implements clearing of a collection. |
|
![]() |
Identifies a row in a worksheet. |
|
![]() |
Provides data for the WorksheetListener.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 row-related events. |
|
![]() |
Contains the arguments passed to the WorksheetListener.rowMoved event. |
|
![]() |
Contains the arguments passed to the WorksheetListener.rowsRemoved event. |
|
![]() |
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 WorkbookListener.serializeColumnTag and WorkbookListener.deserializeColumnTag event handlers. |
|
![]() |
Provides data for the WorkbookListener.serializeData and WorkbookListener.deserializeData event handlers. |
|
![]() |
Provides data for the WorkbookListener.serializeRowTag and WorkbookListener.deserializeRowTag event handlers. |
|
![]() |
Provides data for the WorkbookListener.serializeTag and WorkbookListener.deserializeTag event handlers. |
|
![]() |
Represents a key in a sorting operation. |
|
![]() |
Specifies the order of a sorting operation, ascending or descending. |
|
![]() |
Provides data for the WorksheetListener.cellStyleChanged event. |
|
![]() |
Represents a copy of the cell styles in a worksheet region. Instances of this class can be obtained by calling the Worksheet.copyStyles method of a Worksheet. |
|
![]() |
|
|
![]() |
Provides methods for culture-aware parsing and formatting of Duration objects. |
|
![]() |
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 WorksheetListener.validationFailed event. |
|
![]() |
The main document class, contains a collection of worksheets, named ranges and other related objects. |
|
![]() |
Defines events raised by Workbook objects. |
|
![]() |
Represents a control that displays Workbook objects. |
|
![]() |
Defines events raised by WorkbookView objects. |
|
![]() |
Represents a worksheet in a workbook, that is, a rectangular grid of cells containing data. |
|
![]() |
|
|
![]() |
Provides data for the WorkbookListener.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 displays 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. |
|
![]() |
|
|
![]() |
Receives values parsed from CSV file. |
|
![]() |
|
|
![]() |
|
|
![]() |
|
|
![]() |
Defines events raised by view objects. |
|
![]() |
Defines events raised by Workbook objects. |
|
![]() |
Defines events raised by WorkbookView objects. |
|
![]() |
Defines events raised by Worksheet objects. |
|
![]() |
|
Enumeration | Description | |
---|---|---|
![]() |
Identifies the distinct selection handles of an interactive object. |
|
![]() |
Applies to WorkBookView indicating behavior of tab control arrow buttons. |
|
![]() |
Indicates an autofiltering operator. |
|
![]() |
Indicates the cause of a cell change. |
|
![]() |
|
|
![]() |
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 to handle pasting data into merged cells. |
|
![]() |
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 the spreadsheet cells selection type. |
|
![]() |
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. |