GridWorksheetCollection

GridWorksheetCollection class

Collects the objects that represent the individual rows in a worksheet.

public class GridWorksheetCollection : ICollection, ISerializable

Properties

Name Description
ActiveSheetIndex { get; set; }
Count { get; }
DefaultFontName { get; set; } Gets or sets the control’s default font name.
DefaultFontSize { get; set; } Gets or sets the control’s default font size.
IsSynchronized { get; } Gets a value indicating if access to the ICollection is synchronized (thread-safe).
Item { get; } Gets the Worksheet element at the specified index. (2 indexers)
Names { get; } Gets the collection of all the Name objects in the spreadsheet.
NumberDecimalSeparator { get; set; } Gets or sets the decimal separator for formatting/parsing numeric values. Default is the decimal separator of current Region.
SyncRoot { get; } Gets an object that can be used to synchronize access to the ICollection.

Methods

Name Description
Add() Adds a worksheet to the collection.
Add(object) Adds a sheet object.
Add(string) Adds a worksheet to the collection.
AddCopy(int) Adds a worksheet to the collection and copies data from an existed worksheet.
AddCopy(string) Adds a worksheet to the collection and copies data from an existed worksheet.
CalculateFormula() Calculates the result of formulas.
Clear() Clear all worksheets.
CopyTo(Array, int) Copys contents to an array.
GetEnumerator() Gets the rows enumerator
ImportDataView(DataView, TableItemStyle, TableItemStyle) Imports from a DataView. Creates a sheet with the DataView’s table name automatically.
ImportDataView(DataView, TableItemStyle, TableItemStyle, string, int, int) Imports from a DataView to the specified sheet and position.
Insert(int, string)
RemoveAt(int) Removes the element at a specified index.
RemoveAt(string) Removes the element at a specified name.
SetVisible(string, bool) Sets the visible options.
SwapSheet(int, int) Swaps the two sheets.

See Also