Class GridWorksheetCollection
Contents
[
Hide
]GridWorksheetCollection class
Encapsulates a collection of GridWorksheet
objects.
public class GridWorksheetCollection : CollectionBase, ISerializable
Properties
Name | Description |
---|---|
ActiveSheetIndex { get; set; } | Represents the index of active worksheet when the spreadsheet is opened. |
Count { get; } | Gets the size of enumerator |
DefaultFontName { get; set; } | Gets or sets the control’s default font name. |
DefaultFontSize { get; set; } | ????????? |
IsSynchronized { get; } | Gets a value indicating if access to the ICollection is synchronized (thread-safe). |
Item { get; } | Gets the GridWorksheet 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) | Insert a worksheet. |
RemoveAt(int) | Removes the element at a specified index. |
RemoveAt(string) | Removes the element at a specified name. |
SetVisible(string, bool) | Sets the visible for the sheet . |
SwapSheet(int, int) | Swaps the two sheets. |
See Also
- namespace Aspose.Cells.GridWeb.Data
- assembly Aspose.Cells.GridWeb