Class CalcSheetList
Wrapper ArrayList that holds a collection of CalcSheets.
Inheritance
System.Object
CalcSheetList
Namespace: Syncfusion.XlsIO.Calculate
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public class CalcSheetList : List<object>Constructors
CalcSheetList()
Default constructor.
Declaration
public CalcSheetList()CalcSheetList(CalcSheet[], CalcWorkbook)
Creates an CalcSheetList instance owned by the given workbook with the given CalcSheet list.
Declaration
public CalcSheetList(CalcSheet[] list, CalcWorkbook parentWorkBook)Parameters
| Type | Name | Description |
|---|---|---|
| CalcSheet[] | list | list of CalcSheets |
| CalcWorkbook | parentWorkBook | The Workbook |
Properties
Item[Int32]
Gets or sets the CalcSheet at the given index.
Declaration
public CalcSheet this[int i] { get; set; }Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | i | The sheet index. |
Property Value
| Type |
|---|
| CalcSheet |
Item[String]
Gets or sets the CalcSheet with a given name.
Declaration
public CalcSheet this[string sheetName] { get; set; }Parameters
| Type | Name | Description |
|---|---|---|
| System.String | sheetName | The sheet name. |
Property Value
| Type |
|---|
| CalcSheet |
Methods
Add(Object)
A method that adds a new CalcSheet.
Declaration
public void Add(object o)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | o | The CalcSheet to be added. |
Insert(Int32, Object)
Not supported.
Declaration
public void Insert(int index, object o)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | index | |
| System.Object | o |
InsertRange(Int32, ICollection)
Not supported.
Declaration
public void InsertRange(int index, ICollection c)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | index | |
| System.Collections.ICollection | c |
NameToIndex(String)
Returns the index for a CalcSheet.
Declaration
public int NameToIndex(string sheetName)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | sheetName | The name of the CalcSheet. |
Returns
| Type | Description |
|---|---|
| System.Int32 | The index of the CalcSheet. |
Remove(Object)
A method that removes a CalcSheet.
Declaration
public void Remove(object o)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | o | The CalcSheet to be removed. |
RemoveAt(Int32)
Removes a CalcSheet.
Declaration
public void RemoveAt(int index)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | index | The index of the CalcSheet to be removed. |
ToArray()
The CalcSheets in this collection.
Declaration
public CalcSheet[] ToArray()Returns
| Type | Description |
|---|---|
| CalcSheet[] | Returns a CalcSheet[]. |