Search
MindFusion.Spreadsheet Namespace
Classes Interfaces Enumerations
 

 Classes

  Class Description

AddItemCommand(T)

Implements addition of items to a collection.

Annotation

Represents a comment of a cell within a worksheet.

AutoFilter

Represents autofiltering inside a worksheet.

BinaryContext

Contains methods that help serializing and deserializing complex objects to and from binary streams.

CalcExporter

CalcExporter lets you export Workbook objects to OpenOffice Calc spreadsheets.

CalcImporter

CalcImporter lets you import OpenOffice Calc spreadsheets into a Workbook.

Cell

Identifies a single cell in a Worksheet.

CellAnnotation

Represents the interactive object containing a comment for a cell within a worksheet.

CellChangedEventArgs

Provides data for the CellChanged event.

CellCollection

Represents a specialized collection for worksheet cells.

CellData

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.

CellEventArgs

Provides data for events related to individual cells.

CellIndex

An immutable representation of a cell reference.

CellMouseEventArgs

Contains the arguments passed to cell-related mouse events.

CellRange

Identifies a range of cells in a Worksheet.

CellRangeCollection

Represents a specialized collection for cell ranges.

CellValidationEventArgs

Provides data for validation events related to individual cells.

ChangeWorksheetCommand

Represents a command that can track and undo changes of a Worksheet.

Column

Identifies a column in a worksheet.

ColumnChangedEventArgs

Provides data for the ColumnChanged event.

ColumnCollection

Represents a specialized collection for worksheet columns.

ColumnEventArgs

Contains the arguments passed to column-related events.

ColumnMouseEventArgs

Contains the arguments passed to column-related mouse events.

ColumnRange

Identifies a range of columns in a Worksheet.

ColumnRangeEventArgs

Contains the arguments passed to events related to multiple column.

ColumnRangeMovingEventArgs

Contains the arguments passed to validation events related to multiple columns.

ColumnRangeResizingEventArgs

Contains the arguments passed to validation events related to multiple columns.

Command

Represents an action that modifies the workbook and whose effects can be undone.

CompositeCommand

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.

Converter

Provides capabilities to convert various types to and from strings in a culture-independent way.

CsvExporter

CsvExporter lets you export Worksheet data into .csv file.

CsvImporter

CsvImporter lets you import .csv files into a Worksheet.

CurrencyCodeInfo

Represents a currency ISO code to locale relationship.

CurrencyCodes

Represents a helper class containing the definitions of currency ISO codes to locale relationships.

DefaultNumericFormats

Contains predefined format strings for different numeric formats.

DisposableCommand

Represents a command that implements the IDisposable interface.

DrawColumnEventArgs

Provides data for the DrawColumn event.

Drawing

Represents a drawing within a worksheet. A drawing can contain unlimited number of visual elements such as pictures, diagrams and charts.

DrawRowEventArgs

Provides data for the DrawRow event.

ExcelExporter

ExcelExporter lets you export Workbook objects to Excel Open XML documents.

ExcelImporter

ExcelImporter lets you import Excel Open XML documents into a Workbook.

Filter

Represents a filter for a single column.

FormattedText

Represents a sequence of text fragments with different formatting (font, size, color).

HtmlExporter

HtmlExporter lets you export Workbook objects to HTML files.

HtmlExporterBase

Represents the base class for HTML exporters.

HtmlExporterBase.MetaTagNames

Provides common HTML meta-tag names.

Hyperlink

Represents a hyperlink associated with a worksheet cell.

ImageExporter

Exports worksheets as images.

InplaceEditEventArgs

Contains the arguments passed to the InplaceEditStarted and InplaceEditEnded event handlers.

InplaceEditValidationEventArgs

Contains the arguments passed to the InplaceEditStarting and InplaceEditEnding event handlers.

InteractiveObject

Represents a worksheet object that can be modified interactively by the user.

Measure

Represents amounts of specific units.

MeasureUnit

Specifies units of measure.

MergedCellsCollection

Represents a specialized collection for merged cells in a worksheet, each merged cell is represented by a CellRange object.

MhtmlExporter

HtmlExporter lets you export Workbook objects to MHTML files.

MoveItemCommand(T)

Implements moving of items within a collection.

NamedCollection(T)

Represents a collection of objects that can be manipulated by name. The objects in the collection are required to have unique names.

NamedRange

Represents a named range of cells.

NamedRangeCollection

Represents a specialized collection of NamedRange objects.

NumericFormatInfo

Represents a numeric format within a workbook.

ObjectEventArgs

Provides data for events related to interactive objects.

ObjectInteractionEventArgs

Provides data for events related to interactive objects.

ObjectInteractionValidationEventArgs

Contains the arguments passed to handlers of object validation events.

ObjectMouseEventArgs

Contains the arguments passed to object-related mouse events.

ObjectValidationEventArgs

Contains the arguments passed to handlers of object validation events.

OutlineEventArgs

Contains the arguments passed to the RowOutlineLevelToggled and ColumnOutlineLevelToggled event handlers.

PdfExporter

Exports worksheets as PDF files.

Picture

Represents a picture in a drawing within a worksheet.

PropertyEventArgs

Provides data for the PropertyValueChanged event.

RemoveItemCommand(T)

Implements deletion of items from a collection.

ReplaceItemCommand(T)

Implements replacement of items in a collection.

ResetCollectionCommand(T)

Implements clearing of a collection.

Row

Identifies a row in a worksheet.

RowChangedEventArgs

Provides data for the RowChanged event.

RowCollection

Represents a specialized collection for worksheet rows.

RowEventArgs

Contains the arguments passed to row-related events.

RowMouseEventArgs

Contains the arguments passed to row-related mouse events.

RowRange

Identifies a range of rows in a Worksheet.

RowRangeEventArgs

Contains the arguments passed to events related to multiple rows.

RowRangeMovingEventArgs

Contains the arguments passed to validation events related to multiple rows.

RowRangeResizingEventArgs

Contains the arguments passed to validation events related to multiple rows.

Run

Represents a fragment of text with uniform formatting in a FormattedText object.

Selection

Represents a set of selected cells and objects within a grid view.

SerializeColumnTagEventArgs

Provides data for the SerializeColumnTag and DeserializeColumnTag event handlers.

SerializeDataEventArgs

Provides data for the SerializeData and DeserializeData event handlers.

SerializeRowTagEventArgs

Provides data for the SerializeRowTag and DeserializeRowTag event handlers.

SerializeTagEventArgs

Provides data for the SerializeTag and DeserializeTag event handlers.

SortKey

Represents a key in a sorting operation.

SortOptions

Specifies the order of a sorting operation, ascending or descending.

StyleData

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.

TrackChangesCommand

Represents a command that can track and undo changes of INotifyPropertyValueChanged objects.

UndoableCollection(T)

Represents a strongly-typed collection that supports undo and redo.

UndoEventArgs

Contains the arguments passed to the ActionUndone and ActionRedone event handlers.

ValidationFailedEventArgs

Provides data for the ValidationFailed event.

Workbook

The main document class, contains a collection of worksheets, named ranges and other related objects.

WorkbookPrinter

Provides print and print preview for Workbook objects.

WorkbookView

Represents a control that can display Workbook objects.

Worksheet

Represents a worksheet in a workbook, that is, a rectangular grid of cells containing data.

WorksheetChangedEventArgs

Provides data for the WorksheetChanged event.

WorksheetCollection

Represents a specialized collection of Worksheet objects.

WorksheetEventArgs

Contains the arguments passed to Worksheet-related events.

WorksheetMouseEventArgs

Contains the arguments passed to Worksheet-related mouse events.

WorksheetValidationEventArgs

Contains the arguments passed to Worksheet-related validation events.

WorksheetView

Represents a control that can display individual Worksheet objects.

XmlContext

Contains methods that help serializing and deserializing complex objects to and from XML documents.

 Interfaces

  Interface Description

IColumnStyle

Represents the style of a column.

IConditionalFormat

Represents conditional format associated with a range of cells.

IConditionalFormatCollection

Represents a collection of IConditionalFormat objects.

IHasName

Defines a name for the type that implements this interface.

IInplaceEditable

Represents an inplace-editable object within a worksheet.

INotifyPropertyValueChanged

Provides notification for property changes.

IRowStyle

Represents the style of a row.

IStyle

Represents the style of an element.

IValidation

Represents data validation associated with a range of cells.

 Enumerations

  Enumeration Description

AdjustmentHandles

Identifies the distinct selection handles of an interactive object.

AutoFilterOperator

Indicates an autofiltering operator.

ComparisonOperator

Specifies an operator for value comparison.

ConditionalFormatType

Specifies the type of a conditional format.

CursorHint

Specifies what mouse cursor to display while a user interacts with the view controls.

DynamicFilterType

Specifies the type of a dynamic autofilter.

FillDate

Specifies the date component to increment when filling dates.

FillDirection

Specifies the direction of a data fill operation.

FillType

Specifies the method used to fill series of cells.

FindWithin

Specifies the target of find and replace operations.

HorizontalAlignment

Specifies the horizontal alignment of an element.

HyperlinkType

Specifies the type of a hyperlink.

LookIn

Specifies whether a find operation should search in cell formulas or values.

ObjectAnchor

Specifies the anchor of a worksheet object.

ObjectAnchorPosition

Specifies the anchor position of a worksheet object.

PageOrder

Specifies the order of printed pages.

PushDirection

Specifies how the existing cells are moved when inserting new cells in a CellRange object.

SearchDirection

Specifies the direction of find and replace operations.

SearchOrder

Specifies the order of find and replace operations.

ShiftDirection

Specifies how the cells are moved when removing cells from a CellRange object.

SortDirection

Specifies the direction of a sorting operation.

SortOrder

Specifies the order of a sorting operation, ascending or descending.

TabAlignment

Specifies the alignment of the tabs in a WorkbookView.

ValidationErrorAction

Specifies the action to perform when data validation fails.

ValidationType

Specifies the type of data validation.

VerticalAlignment

Specifies the vertical alignment of an element.