WorksheetsCollection module

class WorksheetsCollection.WorksheetsCollection(ptr)

Bases: XlsWorksheetsCollection

Add(name: str) → Worksheet

<summary>

Adds a new worksheet.

</summary> <param name=”sheetName”>Worksheet name.</param> <returns>Added worksheet.</returns>

AddCopy

<summary>

Adds copy of worksheet.

</summary> <param name=”sheetIndex”>Sheet index.</param> <returns>Added worksheet.</returns>

Create

<summary>

Create a new worksheet.

</summary> <param name=”name”>Worksheet name</param> <returns></returns>

FindBool(boolValue: bool) → CellRange

<summary>

Finds the cell with the input bool.

</summary> <param name=”boolValue”>Bool value to search for</param> <returns>Found range</returns>

FindDateTime(dateTimeValue: DateTime) → CellRange

<summary>

Finds the cell with the input datetime.

</summary> <param name=”dateTimeValue”>Datetime value to search for</param> <returns>Found range</returns>

FindNumber(doubleValue: float, formulaValue: bool) → CellRange

<summary>

Finds the cell with the input double.

</summary> <param name=”doubleValue”>Double value to search for</param> <param name=”formulaValue”>Indicates whether includes formula value to search for</param> <returns>Found range</returns>

FindString(stringValue: str, formula: bool, formulaValue: bool) → CellRange

<summary>

Finds the cell with the input string.

</summary> <param name=”stringValue”>String value to search for</param> <param name=”formula”>Indicates whether includes formula to search for</param> <param name=”formulaValue”>Indicates whether includes formula value to search for</param> <returns>Found range</returns>

FindTimeSpan(timeSpanValue: TimeSpan) → CellRange

<summary>

Finds the cell with the input time span.

</summary> <param name=”timeSpanValue”>Time span value to search for.</param> <returns>Found range.</returns>

Remove(sheet: Worksheet)

<summary>

Remove worksheet from collection.

</summary> <param name=”sheet”>Worksheet object.</param>

get_Item

<summary>

Returns a single object from a collection. Read-only.

</summary>