com.mindfusion.spreadsheet.WorksheetCollection Members

WorksheetCollection Members

CollapseAll image

Members Options: Show All

Include Inherited Members
Include Protected Members

General Information

What's New in this Release

Version History

Programming Interface Overview

com.mindfusion.common

com.mindfusion.drawing

com.mindfusion.graphs

com.mindfusion.pdf

com.mindfusion.spreadsheet

ActivationEvent Class

AddItemCommand(T) Class

AdjustmentHandles Enumeration

Annotation Class

ArrowActions Enumeration

AutoFilter Class

AutoFilterChangedEvent Class

AutoFilterOperator Enumeration

CalcExporter Class

CalcImporter Class

CellAnnotation Class

CellChangeContext Enumeration

CellChangedEvent Class

CellCollection Class

CellEvent Class

CellIndex Class

CellMouseEvent Class

CellParsingEvent Class

CellRange Class

CellRangeCollection Class

CellRangeEvent Class

CellRepainterListener Interface

CellsEvent Class

CellsInsertedEvent Class

CellsMovedEvent Class

CellsRemovedEvent Class

CellsSortedEvent Class

CellStorageEvent Class

CellValidationEvent Class

ChangeWorksheetCommand Class

CollectionChangedAction Enumeration

CollectionChangedEvent Class

CollectionListener Interface

ColumnChangedEvent Class

ColumnCollection Class

ColumnEvent Class

ColumnMouseEvent Class

ColumnRange Class

ColumnRangeEvent Class

ColumnsEvent Class

ColumnsMovedEvent Class

ColumnsRemovedEvent Class

ComparisonOperator Enumeration

CompositeCommand Class

ConditionalFormatType Enumeration

Converter Class

CsvExporter Class

CsvImporter Class

CurrencyCodeInfo Class

CurrencyCodes Class

CursorHint Enumeration

DataObjectTransferable Class

DefaultNumericFormats Class

DisposableCommand Class

DrawCellEvent Class

DrawColumnEvent Class

DrawRowEvent Class

DropDownEventObject Class

DropDownSelectionEventObject Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

ExternalizableImage Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

FindWithin Enumeration

FormattedText Class

FormulaTextBoxListener Interface

HorizontalAlignment Enumeration

HtmlExporter Class

HtmlExporterBase Class

Hyperlink Class

HyperlinkType Enumeration

IColumnStyle Interface

IConditionalFormat Interface

IConditionalFormatCollection Interface

IHasName Interface

IInplaceEditable Interface

ImageExporter Class

INotifyPropertyValueChanged Interface

InplaceEditEvent Class

InplaceEditValidationEvent Class

InteractiveObject Class

IRowStyle Interface

IStyle Interface

IValidation Interface

Localization Class

LookIn Enumeration

MeasureUnit Class

MergedCellsCollection Class

MetaTagNames Class

MhtmlExporter Class

MoveItemCommand(T) Class

NamedCollection(T) Class

NamedCollectionListener(T) Interface

NamedRange Class

NamedRangeCollection Class

NumericFormatInfo Class

ObjectAnchor Enumeration

ObjectAnchorPosition Enumeration

ObjectChangedEvent Class

ObjectEvent Class

ObjectInteractionEvent Class

ObjectInteractionValidationEvent Class

ObjectMouseEvent Class

ObjectValidationEvent Class

OffscreenContext Class

OutlineEvent Class

PageOrder Enumeration

PasteToMerged Enumeration

PdfExporter Class

PrintOptions Class

PrintPreview Class

PushDirection Enumeration

RemoveItemCommand(T) Class

RenderContext Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

Rotate Enumeration

RowChangedEvent Class

RowCollection Class

RowMouseEvent Class

RowRangeEvent Class

RowReceiver Interface

RowsEvent Class

RowsMovedEvent Class

RowsRemovedEvent Class

SearchDirection Enumeration

SearchOrder Enumeration

Selection Class

SelectionAdapter Class

SelectionListener Interface

SelectionType Enumeration

SerializeColumnTagEvent Class

SerializeDataEvent Class

SerializeRowTagEvent Class

SerializeTagEvent Class

ShiftDirection Enumeration

SortDirection Enumeration

SortOptions Class

SortOrder Enumeration

StateButtonListener Interface

StyleChangedEvent Class

StyleData Class

TabAdapter Class

TabAlignment Enumeration

TabListener Interface

TimeSpanUtilities Class

TrackChangesCommand Class

UndoableCollection(T) Class

UndoEvent Class

ValidationErrorAction Enumeration

ValidationFailedEvent Class

ValidationType Enumeration

VerticalAlignment Enumeration

ViewListener Interface

WorkbookAdapter Class

WorkbookListener Interface

WorkbookView Class

WorkbookViewAdapter Class

WorkbookViewListener Interface

Worksheet Class

WorksheetAdapter Class

WorksheetChangedEvent Class

WorksheetCollection Class

WorksheetCollection Members

WorksheetCollection Methods

WorksheetEvent Class

WorksheetListener Interface

WorksheetMouseEvent Class

WorksheetValidationEvent Class

WorksheetView Class

WorksheetViewAdapter Class

WorksheetViewListener Interface

XmlContext Class

com.mindfusion.spreadsheet.charts

com.mindfusion.spreadsheet.expressions

com.mindfusion.spreadsheet.standardforms

Function Reference

Technical Support

MindFusion Products

Represents a specialized collection of Worksheet objects.

The following tables list the members exposed by the WorksheetCollection type.

Public Methods

	Name	Description
	add	Overloaded. Creates a new Worksheet object and adds it to the end of the collection.
	addCollectionListener	Registers listener so that it will receive events from the collection. (Inherited from UndoableCollection.)
	addNamedCollectionListener	Registers listener so that it will receive events from the collection. (Inherited from NamedCollection.)
	clear	Clears all elements from the collection. If the collection is empty, the method has no effect.
	contains	Determines whether an element is in the collection. (Inherited from UndoableCollection.)
	contains	Determines whether an element with the specified name is in the collection. (Inherited from NamedCollection.)
	get	Gets the item at the specified index. (Inherited from UndoableCollection.)
	get	Gets the item with the specified name. If there is no item with the specified name, the indexer has no effect. (Inherited from NamedCollection.)
	indexOf	Searches for the specified item and returns the zero-based index of the first occurrence within the entire collection. (Inherited from UndoableCollection.)
	insert	Overloaded.
	iterator	(Inherited from UndoableCollection.)
	move	Moves the specified Worksheet object from its current position to the specified index. If the worksheet is not part of the collection, the method has no effect.
	remove	Overloaded. Removes a Worksheet object from the collection.
	removeAt	Removes the Worksheet object at the specified index.
	removeCollectionListener	Unregisters listener so that it will no longer receive collection events. (Inherited from UndoableCollection.)
	removeNamedCollectionListener	Unregisters listener so that it will no longer receive collection events. (Inherited from NamedCollection.)
	size	Gets the number of items in the collection. (Inherited from UndoableCollection.)

Protected Methods

	Name	Description
	getWorkbook	Gets a reference to the parent Workbook object. (Inherited from UndoableCollection.)
	onCollectionChanged	(Inherited from NamedCollection.)
	trackAdd	Adds the specified item to the collection. If undo is enabled, the item is added through a command. Otherwise, the item is added directly. (Inherited from UndoableCollection.)
	trackClear	Clears the collection. If undo is enabled, the collection is cleared through a command. Otherwise, the collection is cleared directly. (Inherited from UndoableCollection.)
	trackMove	Moves the specified item to another position. If undo is enabled, the item is moved through a command. Otherwise, the item is moved directly. (Inherited from UndoableCollection.)
	trackRemove	Removes the specified item to the collection. If undo is enabled, the item is removed through a command. Otherwise, the item is removed directly. (Inherited from UndoableCollection.)
	trackReplace	Removes the specified item in the collection. If undo is enabled, the item is replaced through a command. Otherwise, the item is replaced directly. (Inherited from UndoableCollection.)

See Also

WorksheetCollection Class
com.mindfusion.spreadsheet Namespace