ExcelWorksheetsCollection Class

Represents the collection of Excel worksheets in a workbook

Inheritance Hierarchy

SystemObject
ExpertXls.ExcelLibExcelWorksheetsCollection

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 9.0.0

Syntax

public class ExcelWorksheetsCollection : IEnumerable

Public Class ExcelWorksheetsCollection
	Implements IEnumerable

The ExcelWorksheetsCollection type exposes the following members.

Properties

	Name	Description
	Count	Gets the number of worksheets in the collection.
	ItemInt32	Gets the worksheet at worksheetIndex from the collection.
	ItemString	Gets the worksheet with the specified name from the collection.

Methods

	Name	Description
	AddWorksheet	Adds a new worksheet to the worksheets collection
	AddWorksheet(String)	Adds a new worksheet with the specified name to the worksheets collection
	GetEnumerator	Gets the worksheets collection enumerator
	RemoveWorksheet(ExcelWorksheet)	Removes the specified worksheet from collection
	RemoveWorksheet(Int32)	Removes the worksheet at the specified zero based index from collection.
	RemoveWorksheet(String)	Removes the worksheet with the specified name from collection