GrapeCity.Documents.Excel.IWorksheets

IWorksheets Interface

Represents a collection of all the sheets in the workbook.

public interface IWorksheets : IEnumerable<IWorksheet>, IEnumerable

Public Interface IWorksheets
    Inherits IEnumerable(Of IWorksheet), IEnumerable

Name	Description
Count	Returns the number of objects in the collection (read-only).
this[int]	Gets the worksheet using the index.
this[string]	Gets the worksheet using the name.
this[string[]]	Gets worksheets by names.

Name	Description
Add()	Creates a new worksheet. The new worksheet becomes the active sheet.
Add(SheetType)	Creates a new sheet. The new sheet becomes the active sheet.
AddAfter(IWorksheet)	Creates a new worksheet and inserts it after the specified sheet.
AddBefore(IWorksheet)	Creates a new worksheet and inserts it before the specified sheet.
Contains(IWorksheet)	Returns true if the specified Worksheet is contained by the collection of worksheets; otherwise, false is returned.
Copy(IWorkbook)	Copies the sheet collection to the end of the specified workbook.
CopyAfter(IWorksheet)	Copies the sheet collection to the location after the specified sheet.
CopyBefore(IWorksheet)	Copies the sheet collection to the location before the specified sheet.
IndexOf(IWorksheet)	Returns the zero-based index of the specified worksheet in the collection.
Move(IWorkbook)	Moves the sheet collection to the end of the specified workbook.
MoveAfter(IWorksheet)	Moves the sheet collection to the location after the specified sheet.
MoveBefore(IWorksheet)	Moves the sheet collection to the location before the specified sheet.
Select(bool)	Selects the object.