XlsName module

class XlsName.XlsName

Bases: XlsObject, INamedRange, IXLSRange

Activate
AddComment() → ICommentShape
AutoFitColumns()
AutoFitRows()
property BooleanValue: bool
BorderAround
BorderInside
BorderNone()
property Borders: IBorders
property BuiltInStyle: BuiltInStyles
property CellStyleName: str
Clear
ClearContents()
Clone
CollapseGroup(groupBy: GroupByType)
property Column: int
property ColumnGroupLevel: int
property ColumnWidth: float
property Columns: ListXlsRanges
property Comment: ICommentShape
property ConditionalFormats: ConditionalFormats
<summary>

Collection of conditional formats.

</summary>

ConvertFullRowColumnName(version: ExcelVersion)
CopyTo(destination: IXLSRange) → IXLSRange
property Count: int
property DataValidation: Validation
property DateTimeValue: DateTime
Delete()
property EndCell: IXLSRange
property EntireColumn: IXLSRange
property EntireRow: IXLSRange
property EnvalutedValue: str
<summary>

Returns the calculated value of a formula.

</summary>

property ErrorValue: str
ExpandGroup
FindFirst
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
property HasBoolean: bool
property HasDataValidation: bool
property HasDateTime: bool
property HasError: bool
property HasExternalFormula: bool
<summary>

Indicates is current range has external formula. Read-only.

</summary>

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>

property IgnoreErrorOptions: IgnoreErrorType
<summary>

Represents ignore error options. If not single cell returs concatenateed flags.

</summary>

property IndentLevel: int
property Index: int
Intersect(range: IXLSRange) → IXLSRange
property IsBlank: bool
property IsBuiltIn: bool
property IsExternName: bool
property IsFormulaHidden: bool
property IsFunction: bool
property IsGroupedByColumn: bool
property IsGroupedByRow: bool
property IsInitialized: bool
property IsLocal: bool
property IsStringsPreserved: bool
<summary>

Indicates whether all values in the range are preserved as strings.

</summary>

property IsWrapText: bool
property LastColumn: int
property LastRow: int
Merge
property MergeArea: IXLSRange
property Name: str
property NameLocal: str
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
property RefersToRange: IXLSRange
property RichText: IRichTextString
property Row: int
property RowGroupLevel: int
property RowHeight: float
property Rows: ListXlsRanges
property Scope: str
SetIndex
property Style: IStyle
property Text: str
property TimeSpanValue: TimeSpan
UnMerge()
property Value: str
property Value2: SpireObject
property ValueR1C1: str
property VerticalAlignment: VerticalAlignType
property Visible: bool
property Worksheet: IWorksheet
get_Item
set_Item(row: int, column: int, value: IXLSRange)