XlsRangesCollection module

class XlsRangesCollection.XlsRangesCollection(ptr)

Bases: CollectionBase[XlsRange], IXLSRanges, ICombinedRange

Activate(scroll: bool) → IXLSRange
<summary>
Activages a single cell, scroll to it and activates the respective sheet

To select a range of cells, use the Select method.

</summary> <param name=”scroll”>True to scroll to the cell</param> <returns></returns>

AddComment() → ICommentShape
AutoFitColumns()
<summary>

Autofits all columns.

</summary>

AutoFitRows()
<summary>

Autofits all rows.

</summary>

property BooleanValue: bool
BorderAround
BorderInside
<summary>

Sets inside border for current range.

</summary>

BorderNone()
property Borders: IBorders
property BuiltInStyle: BuiltInStyles
property CellStyleName: str
property CellsCount: int
ClearConditionalFormats()
<summary>

Clears conditional formats.

</summary>

ClearContents()
<summary>

Clear the contents of the Range.

<example>The following code illustrates how to clear the Range: <code> //Create worksheet Workbook workbook = new Workbook(); workbook.LoadFromFile(“Sample.xlsx”); Worksheet worksheet = workbook.Worksheets[0]; //Clears the Range C2 worksheet.Range[“C2”].ClearContents(); //Save to file workbook.SaveToFile(“ClearContents.xlsx”); </code> </example>

</summary>

CollapseGroup(groupBy: GroupByType)
property Column: int
property ColumnGroupLevel: int
property ColumnWidth: float
property Columns: ListXlsRanges
property Comment: ICommentShape
property ConditionalFormats: ConditionalFormats
property DataValidation: Validation
property DateTimeValue: DateTime
property EndCell: IXLSRange
property EntireColumn: IXLSRange
property EntireRow: IXLSRange
property EnvalutedValue: str
property ErrorValue: str
ExpandGroup
property Formula: str
property FormulaArray: str
property FormulaArrayR1C1: str
property FormulaBoolValue: bool
property FormulaDateTime: DateTime
property FormulaErrorValue: str
property FormulaNumberValue: float
property FormulaR1C1: str
property FormulaStringValue: str
FreezePanes()
GetEnumerator() → IEnumerator
GetRectangles() → List[Rectangle]
GetRectanglesCount() → int
property HasBoolean: bool
property HasDataValidation: bool
property HasDateTime: bool
property HasError: bool
property HasExternalFormula: bool
property HasFormula: bool
property HasFormulaArray: bool
property HasFormulaBoolValue: bool
property HasFormulaDateTime: bool
property HasFormulaErrorValue: bool
property HasFormulaNumberValue: bool
property HasFormulaStringValue: bool
property HasMerged: bool
property HasNumber: bool
property HasRichText: bool
property HasString: bool
property HasStyle: bool
property HorizontalAlignment: HorizontalAlignType
property HtmlString: str
<summary>

Gets and sets the html string which contains data and some formattings in this cell.

</summary>

<summary>

Returns hyperlinks for this ranges collection.

</summary>

property IgnoreErrorOptions: IgnoreErrorType
property IndentLevel: int
Intersect(range: IXLSRange) → IXLSRange
property IsBlank: bool
property IsFormulaHidden: bool
property IsGroupedByColumn: bool
property IsGroupedByRow: bool
property IsInitialized: bool
property IsStringsPreserved: bool
property IsWrapText: bool
property LastColumn: int
property LastRow: int
Merge
property MergeArea: IXLSRange
property NumberFormat: str
property NumberText: str
property NumberValue: float
property RangeAddress: str
property RangeAddressLocal: str
property RangeGlobalAddress: str
property RangeGlobalAddress2007: str
property RangeR1C1Address: str
property RangeR1C1AddressLocal: str
Remove(range: IXLSRange)
property RichText: IRichTextString
property Row: int
property RowGroupLevel: int
property RowHeight: float
property Rows: ListXlsRanges
property Style: IStyle
property Text: str
property TimeSpanValue: TimeSpan
UnMerge()
property Value: str
property Value2: SpireObject
property VerticalAlignment: VerticalAlignType
property Worksheet: IWorksheet
property WorksheetName: str
get_Item
set_Item