h:SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SSK J r J r J r Jr "SS \ 5r"S S \5rg ) )copy) attrgetter)Strict)MinMax)UniqueSequence) Serialisable)range_boundariesrange_to_tupleget_column_letterquote_sheetnamec\rSrSrSr\"SS\S9r\"SS\S9r\"SS\S9r \"SS\S9r S(Sjr \ S 5r \ S 5r\ S 5r\ S 5r\ S 5rSrSrSrSrSrS)SjrSrSrSr\rSrSrSr\rSr Sr!Sr"Sr#\#r$Sr%\%r&Sr'S*S jr(S*S!jr)\ S"5r*\ S#5r+\ S$5r,\ S%5r-\ S&5r.S'r/g)+ CellRangea Represents a range in a sheet: title and coordinates. This object is used to perform operations on ranges, like: - shift, expand or shrink - union/intersection with another sheet range, We can check whether a range is: - equal or not equal to another, - disjoint of another, - contained in another. We can get: - the size of a range. - the range bounds (vertices) - the coordinates, - the string representation, ifG)minmax expected_typeiNcUb&SU;a[U5unup#pEO[U5up#pEX lX0lX@lXPlX`lX$:aSn[URX$S95eX5:aSn[URX5S95eg)N!z({max_col} must be greater than {min_col})min_colmax_colz({max_row} must be greater than {min_row})min_rowmax_row) r r rrrrtitle ValueErrorformat)self range_stringrrrrrfmts O/var/www/html/env/lib/python3.13/site-packages/openpyxl/worksheet/cell_range.py__init__CellRange.__init__0s  #l">L\>Z;;'75El5S2'      :E$,,PTP\P\]^P^<_``r#c[U[5(d[[[ U555eUR (a&UR UR :wa [ S5egg)z Check whether comparisons between ranges are possible. Cannot compare ranges from different worksheets Skip if the range passed in has no title. z1Cannot work with ranges from different worksheetsN) isinstancer TypeErrorreprtyperrrothers r _check_titleCellRange._check_titlewsN %++De-. . ;;4::4PQ Q5;r#cSnUR(aSnURURRURURS9$)Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)clsrr+)rr __class____name__r+r*s r __repr__CellRange.__repr__s:  ::.Czzdnn55TZZtzzzZZr#cp[URURURUR45$N)hashrrrrr&s r __hash__CellRange.__hash__s&T\\4<<t||LMMr#cxSnURnU(a Sn[U5nURX RS9$)Nz{coord}z{title}!{coord})rr+)rr rr+)rrrs r __str__CellRange.__str__s7  $C#E*EzzZZz88r#cURURURURURUR S9$)Nrrrrr)rHrrrrrr&s r __copy__CellRange.__copy__s8~~dllDLL&*llDLL$(JJ0 0r#c,URU-S::dURU-S::a[SRX55eU=RU- slU=RU- slU=RU- slU=R U- slg)aC Shift the focus of the range according to the shift values (*col_shift*, *row_shift*). :type col_shift: int :param col_shift: number of columns to be moved by, can be negative :type row_shift: int :param row_shift: number of rows to be moved by, can be negative :raise: :class:`ValueError` if any row or column index < 1 rz1Invalid shift value: col_shift={0}, row_shift={1}N)rrrrrr)r col_shift row_shifts r shiftCellRange.shiftsv LL9 $ )||i'1,PWWXamn n !  !  !  ! r#c8URU5 URUR:g=(dY URUR:g=(d9 URUR:g=(d UR UR :g$![a gf=f)z Test whether the ranges are not equal. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* != *other*. T)rDrrrrrrBs r __ne__CellRange.__ne__s    e $ MMT\\ ) -||u}}, -}} , -||u}},    sB BBc.URU5(+$)z Test whether the ranges are equal. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* == *other*. )r^rBs r __eq__CellRange.__eq__s;;u%%%r#cFURU5 URU5$)z Test whether every cell in this range is also in *other*. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* <= *other*. rD_CellRange__supersetrBs r issubsetCellRange.issubsets# % %%r#cTURU5=(a URU5$)z Test whether *other* contains every cell of this range, and more. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* < *other*. )__le__r^rBs r __lt__CellRange.__lt__!{{5!8dkk%&88r#c8URURs=:*=(a& URs=:*=(a UR:*Os =(aJ URURs=:*=(a& URs=:*=(a UR:*$s $rM)rrrrrBs r __supersetCellRange.__supersetsh \\U]] K Kemm K Kt|| K M \\U]] K Kemm K Kt|| K L r#cFURU5 URU5$)z Test whether every cell in *other* is in this range. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* >= *other* (or *other* in *range*). rdrBs r issupersetCellRange.issupersets! % u%%r#cFURU5nURU5$)z? Check whether the range contains a particular cell coordinate )rHrerr+crs r __contains__CellRange.__contains__s!^^E "r""r#cTURU5=(a URU5$)z Test whether this range contains every cell in *other*, and more. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* > *other*. )__ge__r^rBs r __gt__CellRange.__gt__ rlr#cURU5 URUR:aXpURUR:=(d9 URUR :=(d URUR :$)a& Return ``True`` if this range has no cell in common with *other*. Ranges are disjoint if and only if their intersection is the empty range. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: ``True`` if the range has no cells in common with other. )rDr'rrrrrBs r isdisjointCellRange.isdisjointsh %  ;; %% u}},0<<%--/0==4<</ 1r#cxURU5(a[SRX55e[URUR5n[ UR UR 5n[URUR5n[ URUR5n[XBUUS9$)a Return a new range with cells common to this range and *other* :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: the intersecting sheet range. :raise: :class:`ValueError` if the *other* range doesn't intersect with this range. zRange {0} doesn't intersect {0}r%) r}rrrrrrrrrrrCrrrrs r intersectionCellRange.intersection*s ??5 ! !>EEdRS SdllEMM2dllEMM2dllEMM2dllEMM27!(* *r#cNURU5 [URUR5n[URUR5n[UR UR 5n[UR UR 5n[XBUX0RS9$)aW Return the minimal superset of this range and *other*. This new range will contain all cells from this range, *other*, and any additional cells required to form a rectangular ``CellRange``. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: a ``CellRange`` that is a superset of this and *other*. rU) rDrrrrrrrrrs r unionCellRange.unionBsz % dllEMM2dllEMM2dllEMM2dllEMM27!( < /RS/Rs#/RSSSAc[URURS-5Vs/sHoRU4PM sn$s snf)z@A list of cell coordinates that comprise the bottom of the ranger)r.rrrrs r rCellRange.bottomrrc[URURS-5Vs/sHoUR4PM sn$s snf)zCA list of cell coordinates that comprise the left-side of the ranger)r.rrrrr/s r rCellRange.left905T\\4</RS/Rdll#/RSSSrc[URURS-5Vs/sHoUR4PM sn$s snf)zDA list of cell coordinates that comprise the right-side of the ranger)r.rrrrs r rCellRange.rightrr)rrrrr)NNNNNN)rr)rrrr)0rI __module__ __qualname____firstlineno____doc__rintrrrrr!propertyr'r+r1r6r;rDrJrOrRrVr[r^rarfrirjrerqryrvrzr}r__and__r__or__rrrrrrrr__static_attributes__r#r rrs.S9Gs;GS9Gs;GAE37K,FF  NNNNaa R[N90 "( *& &F9  &F#91(**G<&F&&--TT TT TT TTr#rc\rSrSr\"\S9r\"54SjrSr Sr Sr Sr Sr S rS rS rS rS rSrSrSrSrg)MultiCellRangei)rc[U[5(a)UR5Vs/sHn[U5PM nn[ U5Ulgs snfrM)r>strsplitrsetranges)rrrs r r!MultiCellRange.__init__s= fc " ",2LLN;NqilNF;&k rrr)rr+rs r rvMultiCellRange.__contains__s4 eS ! !e$EAzr#cSRUR5Vs/sHn[U5PM sn5nSURRSUS3$s snf)N )joinsortedrrHrIrrrs r rJMultiCellRange.__repr__sN4;;=9=a3q6=9:4>>**+2fXR88:sAcSRUR5Vs/sHn[U5PM sn5nU$s snf)Nr)rrrrs r rRMultiCellRange.__str__s3DKKM:MqCFM:; ;s<c*[[U55$rM)rNrr&s r rOMultiCellRange.__hash__sCIr#c B[UR[SSSS5S9$)z Return a sorted list of items rrrr)key)rrrr&s r rMultiCellRange.sorteds!dkkz)Y S\']^^r#cUn[U[5(a [U5nO [U[5(d [S5eX ;aURR U5 gg)z$ Add a cell coordinate or CellRange zYou can only add CellRangesN)r>rrrraddrts r rMultiCellRange.addsS eS ! !5!BE9--:; ; > KKOOB  r#c(URU5 U$rM)rrr+s r __iadd__MultiCellRange.__iadd__s  r#c[U[5(aURU5nURUR:H$rM)r>rrHrrBs r raMultiCellRange.__eq__s0 uc " "NN5)E{{ell**r#c X:X+$rMrrBs r r^MultiCellRange.__ne__s   r#c,[UR5$rM)boolrr&s r __bool__MultiCellRange.__bool__sDKK  r#cz[U[5(d [U5nURRU5 grM)r>rrremovers r rMultiCellRange.removes+%++e$E 5!r#c#:# URHnUv M g7frMr)rrus r rMultiCellRange.__iter__s++BHsclURVs1sHn[U5iM nn[U5$s snfrM)rrrrs r rVMultiCellRange.__copy__s.#';;/;a$q';/f%%0s1rN)rIrrrrrrrr!rvrJrRrOrrrrar^rrrrVrrr#r rrs\) 4F"e" 9  _   + !!"  &r#rN)roperatorropenpyxl.descriptorsrropenpyxl.descriptors.sequencer!openpyxl.descriptors.serialisableropenpyxl.utilsr r r r rrrr#r rsB''8:TT TTn W&VW&r#