WorksheetCollection Methods

The WorksheetCollection type exposes the following members.

Methods
  NameDescription
Public methodAdd
Adds a worksheet to the collection.
Public methodAdd(String)
Adds a worksheet to the collection.
Public methodCode exampleAdd(SheetType)
Adds a worksheet to the collection.
Public methodAddCopy(Int32)
Adds a worksheet to the collection and copies data from an existed worksheet.
Public methodAddCopy(String)
Adds a worksheet to the collection and copies data from an existed worksheet.
Public methodClear
Clear all worksheets.
Public methodClearPivottables
Clears pivot tables from the spreadsheet.
Public methodCreateRange
Creates a Range object from an address of the range.
Public methodCreateUnionRange
Creates a Range object from an address of the range.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetEnumerator (Inherited from CollectionBase.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetNamedRanges
Gets all pre-defined named ranges in the spreadsheet.
Public methodGetNamedRangesAndTables
Gets all pre-defined named ranges in the spreadsheet.
Public methodGetRangeByName
Gets Range object by pre-defined name.
Public methodGetSheetByCodeName
Gets the worksheet by the code name.
Public methodGetType (Inherited from Object.)
Public methodInsert(Int32, SheetType)
Insert a worksheet.
Public methodInsert(Int32, SheetType, String)
Insert a worksheet.
Protected methodMemberwiseClone (Inherited from Object.)
Protected methodOnClear (Inherited from CollectionBase.)
Protected methodOnClearComplete (Inherited from CollectionBase.)
Protected methodOnInsert (Inherited from CollectionBase.)
Protected methodOnInsertComplete (Inherited from CollectionBase.)
Protected methodOnRemove (Inherited from CollectionBase.)
Protected methodOnRemoveComplete (Inherited from CollectionBase.)
Protected methodOnSet (Inherited from CollectionBase.)
Protected methodOnSetComplete (Inherited from CollectionBase.)
Protected methodOnValidate (Inherited from CollectionBase.)
Public methodRefreshPivotTables
Refreshes all the PivotTables in the WorksheetCollection.
Public methodRegisterAddInFunction(Int32, String)
Adds addin function into the workbook
Public methodRegisterAddInFunction(String, String, Boolean)
Adds addin function into the workbook
Public methodRemoveAt(Int32)
Removes the element at a specified index.
Public methodRemoveAt(String)
Removes the element at a specified name.
Public methodSetOleSize
Sets displayed size when Workbook file is used as an Ole object.
Public methodSortNames
Sorts the defined names.
Public methodSwapSheet
Swaps the two sheets.
Public methodToString (Inherited from Object.)
See Also