Click or drag to resize

WorksheetsCollection Class

Inheritance Hierarchy
SystemObject
  Spire.Xls.Core.Spreadsheet.CollectionsCollectionBaseIWorksheet
    Spire.Xls.Core.Spreadsheet.CollectionsCollectionExtendedIWorksheet
      Spire.Xls.Core.Spreadsheet.CollectionsXlsWorksheetsCollection
        Spire.Xls.CollectionsWorksheetsCollection

Namespace:  Spire.Xls.Collections
Assembly:  Spire.XLS (in Spire.XLS.dll) Version: 11.9.3.0 (11.9.3.5040)
Syntax
public class WorksheetsCollection : XlsWorksheetsCollection

The WorksheetsCollection type exposes the following members.

Properties
  NameDescription
Public propertyCapacity (Inherited from CollectionBaseT.)
Public propertyCount (Inherited from CollectionBaseT.)
Protected propertyInnerList (Inherited from CollectionBaseT.)
Public propertyIsReadOnly (Inherited from CollectionBaseT.)
Public propertyIsRightToLeft (Inherited from XlsWorksheetsCollection.)
Public propertyItemInt32
Returns a single object from a collection. Read-only.
Public propertyItemString
Returns a single object from a collection. Read-only.
Protected propertyList (Inherited from CollectionBaseT.)
Public propertyParent (Inherited from CollectionExtendedT.)
Public propertyUseHashForWorksheetLookup
Toggles worksheet search algorithm when searching worksheet by name.
(Inherited from XlsWorksheetsCollection.)
Public propertyUseRangesCache
Indicates whether all created range objects should be cached.
(Inherited from XlsWorksheetsCollection.)
Top
Methods
  NameDescription
Public methodAdd(String)
Adds a new worksheet.
Public methodAdd(T) (Inherited from CollectionBaseT.)
Public methodAddCopy(Int32)
Adds copy of worksheet.
Public methodAddCopy(IWorksheet)
Adds copy of worksheet.
(Inherited from XlsWorksheetsCollection.)
Public methodAddCopy(IWorksheets) (Inherited from XlsWorksheetsCollection.)
Public methodAddCopy(Worksheet)
Adds copy of worksheet.
Public methodAddCopy(WorksheetsCollection)
Adding worksheets collection to workbook.
Public methodAddCopy(Int32, WorksheetCopyType)
Add a copy of the specified worksheet to the worksheet collection.
(Inherited from XlsWorksheetsCollection.)
Public methodAddCopy(IWorksheet, WorksheetCopyType) (Inherited from XlsWorksheetsCollection.)
Public methodAddCopy(IWorksheets, WorksheetCopyType) (Inherited from XlsWorksheetsCollection.)
Public methodAddCopyAfter(IWorksheet) (Inherited from XlsWorksheetsCollection.)
Public methodAddCopyAfter(IWorksheet, IWorksheet) (Inherited from XlsWorksheetsCollection.)
Public methodAddCopyBefore(IWorksheet) (Inherited from XlsWorksheetsCollection.)
Public methodAddCopyBefore(IWorksheet, IWorksheet) (Inherited from XlsWorksheetsCollection.)
Public methodClear (Inherited from XlsWorksheetsCollection.)
Public methodClone
Creates copy of the collection.
(Inherited from CollectionExtendedT.)
Public methodContains (Inherited from CollectionBaseT.)
Public methodCopyTo (Inherited from CollectionBaseT.)
Public methodCreate
Creates a new worksheet.
Public methodCreate(String)
Create a new worksheet.
Public methodEnsureCapacity
Enlarges internal storage if necessary.
(Inherited from CollectionExtendedT.)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodFindAll(Boolean) (Inherited from XlsWorksheetsCollection.)
Protected methodFindAll(DateTime) (Inherited from XlsWorksheetsCollection.)
Protected methodFindAll(TimeSpan) (Inherited from XlsWorksheetsCollection.)
Protected methodFindAll(Double, FindType) (Inherited from XlsWorksheetsCollection.)
Protected methodFindAll(String, FindType) (Inherited from XlsWorksheetsCollection.)
Public methodFindAll(String, FindType, ExcelFindOptions) (Inherited from XlsWorksheetsCollection.)
Public methodFindAllBool
Finds the cell with the input bool.
Public methodFindAllDateTime
Finds the cell with the input datetime.
Public methodFindAllNumber
Finds the cell with the input double.
Public methodFindAllString
Finds the cell with the input string.
Public methodFindAllTimeSpan
Finds the cell with input timespan
Public methodFindBool
Finds the cell with the input bool.
Public methodFindDateTime
Finds the cell with the input datetime.
Protected methodFindFirst(Boolean) (Inherited from XlsWorksheetsCollection.)
Protected methodFindFirst(DateTime) (Inherited from XlsWorksheetsCollection.)
Protected methodFindFirst(TimeSpan) (Inherited from XlsWorksheetsCollection.)
Protected methodFindFirst(Double, FindType) (Inherited from XlsWorksheetsCollection.)
Protected methodFindFirst(String, FindType) (Inherited from XlsWorksheetsCollection.)
Public methodFindFirst(String, FindType, ExcelFindOptions) (Inherited from XlsWorksheetsCollection.)
Public methodFindNumber
Finds the cell with the input double.
Protected methodFindParent(Type) (Inherited from CollectionExtendedT.)
Protected methodFindParent(Type, Boolean) (Inherited from CollectionExtendedT.)
Public methodFindString
Finds the cell with the input string.
Public methodFindTimeSpan
Finds the cell with the input time span.
Public methodGetEnumerator (Inherited from CollectionBaseT.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodIndexOf (Inherited from CollectionBaseT.)
Public methodInnerAdd (Inherited from XlsWorksheetsCollection.)
Protected methodInnerRemove (Inherited from XlsWorksheetsCollection.)
Public methodInsert (Inherited from CollectionBaseT.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodMove (Inherited from XlsWorksheetsCollection.)
Protected methodOnClear (Inherited from CollectionExtendedT.)
Protected methodOnClearComplete (Inherited from CollectionExtendedT.)
Protected methodOnInsert (Inherited from CollectionExtendedT.)
Protected methodOnInsertComplete (Inherited from CollectionExtendedT.)
Protected methodOnRemove (Inherited from CollectionExtendedT.)
Protected methodOnRemoveComplete (Inherited from CollectionExtendedT.)
Protected methodOnSet (Inherited from CollectionExtendedT.)
Protected methodOnSetComplete (Inherited from CollectionExtendedT.)
Public methodRemove(Int32)
Removes specified worksheet from the collection.
(Inherited from XlsWorksheetsCollection.)
Public methodRemove(String)
Removes specified worksheet from the collection.
(Inherited from XlsWorksheetsCollection.)
Public methodRemove(IWorksheet) (Inherited from XlsWorksheetsCollection.)
Public methodRemove(Worksheet)
Remove worksheet from collection.
Public methodRemoveAt
Removes specified worksheet from the collection.
(Inherited from XlsWorksheetsCollection.)
Protected methodSetParent (Inherited from CollectionExtendedT.)
Public methodToString (Inherited from Object.)
Public methodUpdateSheetIndex Obsolete. (Inherited from XlsWorksheetsCollection.)
Public methodUpdateStringIndexes Obsolete. (Inherited from XlsWorksheetsCollection.)
Top
Events
See Also