Class SheetCollection

Inheritance
System.Object
SheetCollection
Namespace: DRIT.Spreadsheet
Assembly: DRIT.Spreadsheet.dll
Syntax
public class SheetCollection : IEnumerable<Sheet>

Properties

Count

Declaration
public int Count { get; }
Property Value
Type Description
System.Int32

Item[Int32]

Declaration
public Sheet this[int index] { get; }
Parameters
Type Name Description
System.Int32 index
Property Value
Type Description
Sheet

Worksheets

Declaration
public IEnumerable<Worksheet> Worksheets { get; }
Property Value
Type Description
IEnumerable<Worksheet>

Methods

AddChartsheet()

Declaration
public Chartsheet AddChartsheet()
Returns
Type Description
Chartsheet

AddChartsheet(String)

Create a chart sheet and add it to the collection of sheets.

Declaration
public Chartsheet AddChartsheet(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
Chartsheet

AddMacrosheet(String)

Declaration
public Macrosheet AddMacrosheet(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
Macrosheet

AddWorksheet()

Declaration
public Worksheet AddWorksheet()
Returns
Type Description
Worksheet

AddWorksheet(String)

Declaration
public Worksheet AddWorksheet(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
Worksheet

GetEnumerator()

Declaration
public IEnumerator<Sheet> GetEnumerator()
Returns
Type Description
IEnumerator<Sheet>

GetSheet(String)

Declaration
public Sheet GetSheet(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
Sheet

GetWorksheet(String)

Returns the sheet with a given name.

Declaration
public Worksheet GetWorksheet(string name)
Parameters
Type Name Description
System.String name

The name of the sheet. This is case insensitive
Returns
Type Description
Worksheet

The sheet

InsertWorksheet(Int32)

Declaration
public Worksheet InsertWorksheet(int index)
Parameters
Type Name Description
System.Int32 index
Returns
Type Description
Worksheet

Remove(String)

Declaration
public void Remove(string name)
Parameters
Type Name Description
System.String name

RemoveAt(Int32)

Declaration
public void RemoveAt(int index)
Parameters
Type Name Description
System.Int32 index