XlsWorksheetsCollection module

class XlsWorksheetsCollection.XlsWorksheetsCollection(ptr)

Bases: CollectionBase[XlsWorksheet], IWorksheets

Add(sheetName: str) → IWorksheet

AddCopy

AddCopyAfter

AddCopyBefore

Clear()

Create

FindFirst(findValue: str, flags: FindType, findOptions: ExcelFindOptions) → IXLSRange

GetEnumerator() → IEnumerator

InnerAdd(sheet: IWorksheet)

property IsRightToLeft: bool

Move(oldIndex: int, newIndex: int)

Remove

RemoveAt(index: int)

<summary>: Removes specified worksheet from the collection.

</summary> <param name=”index”>Index of the sheet to remove.</param>

UpdateSheetIndex(sheet: XlsWorksheet, iOldRealIndex: int)

property UseHashForWorksheetLookup: bool

<summary>: Toggles worksheet search algorithm when searching worksheet by name.

</summary>

property UseRangesCache: bool

<summary>: Indicates whether all created range objects should be cached.

</summary>