Provides a type-filtered view over a workbook's sheet collection, exposing only sheets of a specific type.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Type Parameters:
T
The type of the sheet.
Syntax:
public abstract class FilteredSheetCollection<T> : IEnumerable<T>, IEnumerable where T : SheetInheritance: objectFilteredSheetCollection<T>
Derived Classes:
Implements:
Methods
Creates a new sheet of type T and appends it at the end of the collection.
public T Add()T
The created sheet.
Removes all sheets of type T from the collection and workbook.
public void Clear()Checks whether the specified sheet exists in the collection.
public bool Contains(T item)The item.
Returns:The value indicating whether the collection contains the specified sheet.
Retrieves the sheet with the specified name (case-insensitive), or null if not found.
public T GetByName(string sheetName)Name of the sheet.
Returns:T
The sheet.
Returns an enumerator that iterates through the collection.
public IEnumerator<T> GetEnumerator()IEnumerator<T>
A IEnumerator<T> that can be used to iterate through the collection.
Implements:
Hides the sheet at the specified zero-based index, making it invisible in the workbook.
Hides the specified sheet, making it invisible in the workbook.
public void Hide(T sheet)The sheet.
Searches for the specified sheet and returns its zero-based index, or -1 if not found.
Creates a new sheet of type T and inserts it at the specified zero-based index.
Removes the specified sheet from the collection and workbook.
public bool Remove(T item)The item.
Returns:The value indicating whether the specified sheet was found.
Removes the sheet at the specified zero-based index from the collection and workbook.
Unhides the sheet at the specified zero-based index, making it visible in the workbook.
Unhides the specified sheet, making it visible in the workbook.
public void Unhide(T sheet)The sheet.
Properties
Gets the number of sheets of type T in the collection.
public int Count { get; }The item count.
Gets the sheet of type T at the specified zero-based index.
Gets the sheet of type T with the specified name (case-insensitive).