Spire.XLS API

IWorksheets Interface

A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public interface IWorksheets : IEnumerable

Public Interface IWorksheets
	Inherits IEnumerable

public interface class IWorksheets : IEnumerable

type IWorksheets =
interface
interface IEnumerable
end

The IWorksheets type exposes the following members.

Properties

	Name	Description
	Count	Returns the number of objects in the collection. Read-only Long.
	Item Int32	Returns a single object from a collection.
	Item String	Returns a single object from a collection.
	Parent	Returns the parent object for the specified object.
	UseRangesCache	Indicates whether all created range objects should be cached.

Methods

	Name	Description
	AddCopyAfter(IWorksheet)	Adds copy of sheet to collection after choosed sheet.
	AddCopyAfter(IWorksheet, IWorksheet)	Adds copy of sheet to collection before choosed sheet.
	AddCopyBefore(IWorksheet)	Adds copy of sheet to collection before choosed sheet.
	AddCopyBefore(IWorksheet, IWorksheet)	Adds copy of sheet to collection before choosed sheet.
	Create	Create a new worksheet.
	Create(String)	Create worksheet with specified name.
	GetEnumerator	Returns an enumerator that iterates through a collection. (Inherited from IEnumerable .)
	Remove(Int32)	Removes specified worksheet from the collection.
	Remove(String)	Removes specified worksheet from the collection.
	Remove(IWorksheet)	Remove worksheet from collection.