+ Ĝi:^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^RI H t H t H t Ht!RR ] 4t!R R ]4tR #) )copy) attrgetter)Strict)MinMax)UniqueSequence) Serialisable)range_boundariesrange_to_tupleget_column_letterquote_sheetnameca]tRt^toRt]!^R]R7t]!^R]R7t]!^R]R7t ]!^R]R7t R&Rlt ] R4t ] R4t] R 4t] R 4t] R 4tR tR tRtRtRtR'RltRtRtRt]tRtRtRt]tRt Rt!Rt"Rt#]#t$Rt%]%t&Rt'R(Rlt(R(Rlt)] R 4t*] R!4t+] R"4t,] R#4t-] R$4t.R%t/Vt0R#)) 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_typeiNc$Ve(RV9d\V4wpwr#rEM\V4wr#rEW nW0nW@nWPnW`nW$8dRp\VPW$R74hW58dRp\VPW5R74hR#)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&&&&&&& f/Users/mibo/.openclaw/workspace/.venv-ak/lib/python3.14/site-packages/openpyxl/worksheet/cell_range.py__init__CellRange.__init__0s  #l">L\>Z;;'75El5S2'      :E$,,PTP\P\]^P^<_``r!c \V\4'g\\\ V444hVP 'd)VP VP 8wd \ R4hR#R#)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_titlewsP %++De-. . ;;;4::4PQ Q5;r!cRpVP'dRpVPVPPVPVPR7#)z<{cls} {coord}>z<{cls} {title!r}!{coord}>)clsrr))rr __class____name__r)r(s& r__repr__CellRange.__repr__s<  :::.Czzdnn55TZZtzzzZZr!cp\VPVPVPVP34#N)hashrrrrr$s&r__hash__CellRange.__hash__s&T\\4<<t||LMMr!cRpVPpV'dRp\V4pVPW PR7#)z{coord}z{title}!{coord})rr))rr rr))rrrs& r__str__CellRange.__str__s7  $C#E*EzzZZz88r!cVPVPVPVPVPVP R7#)rrrrr)rFrrrrrr$s&r__copy__CellRange.__copy__s8~~dllDLL&*llDLL$(JJ0 0r!c bVPV,^8:gVPV,^8:d\RPW44hV;PV, unV;PV, unV;PV, unV;P V, unR#)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 z1Invalid shift value: col_shift={0}, row_shift={1}N)rrrrrr)r col_shift row_shifts&&&rshiftCellRange.shiftsv LL9 $ )||i'1,PWWXamn n !  !  !  ! r!c BVPV4TPTP8g;'g\TPTP8g;'g;TPTP8g;'gTP TP 8g# \dR#i;i)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)rBrrrrrr@s&&r__ne__CellRange.__ne__s    e $ MMT\\ ) - -||u}}, - -}} , - -||u}},    sB BBc .VPV4'*#)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\r@s&&r__eq__CellRange.__eq__s;;u%%%r!c FVPV4VPV4#)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*. rB_CellRange__supersetr@s&&rissubsetCellRange.issubsets# % %%r!c VVPV4;'dVPV4#)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\r@s&&r__lt__CellRange.__lt__${{5!88dkk%&88r!cBVPVPu;8*;'d(VPu;8*;'dVP8*Mu;'dMVPVPu;8*;'d(VPu;8*;'dVP8*#u#rK)rrrrr@s&&r __supersetCellRange.__supersetsn \\U]] K Kemm K Kt|| K M M \\U]] K Kemm K Kt|| K L r!c FVPV4VPV4#)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*). rbr@s&&r issupersetCellRange.issupersets! % u%%r!c FVPV4pVPV4#)z? Check whether the range contains a particular cell coordinate )rFrcrr)crs&& r __contains__CellRange.__contains__s!^^E "r""r!c VVPV4;'dVPV4#)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\r@s&&r__gt__CellRange.__gt__ rjr!c VPV4VPVP8dYrVPVP8;'g;VPVP 8;'gVPVP 8#)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. )rBr%rrrrr@s&&r isdisjointCellRange.isdisjointsr %  ;; %% u}},00<<%--/00==4<</ 1r!c VPV4'd\RPW44h\VPVP4p\ VP VP 4p\VPVP4p\ VPVP4p\WBVVR7#)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{rrrrrrrrrrrArrrrs&& r intersectionCellRange.intersection*s ??5 ! !>EEdRS SdllEMM2dllEMM2dllEMM2dllEMM27!(* *r!c TVPV4\VPVP4p\VPVP4p\VP VP 4p\VP VP 4p\WBVW0PR7#)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*. rS) rBrrrrrrrrr~s&& runionCellRange.unionBsz % dllEMM2dllEMM2dllEMM2dllEMM27!( < /RS/Rs#/RSSSAc \VPVP^,4Uu.uFqPV3NK up#uupi)z@A list of cell coordinates that comprise the bottom of the range)r,rrrrs& rrCellRange.bottomrrc \VPVP^,4Uu.uFqVP3NK up#uupi)zCA list of cell coordinates that comprise the left-side of the range)r,rrrrr-s& rrCellRange.left905T\\4</RS/Rdll#/RSSSrc \VPVP^,4Uu.uFqVP3NK up#uupi)zDA list of cell coordinates that comprise the right-side of the range)r,rrrrs& rrCellRange.rightrr)rrrrr)NNNNNN)rr)rrrr)1rG __module__ __qualname____firstlineno____doc__rintrrrrrpropertyr%r)r/r4r9rBrHrMrPrTrYr\r_rdrgrhrcrorwrtrxr{r__and__r__or__rrrrrrrr__static_attributes____classdictcell__ __classdict__s@rrrs.S9Gs;GS9Gs;GK,FF  NNNNaa R[N90 "( *& &F9  &F#91(**G<&F&&--TT TT TT TTr!rca]tRtRto]!]R7t]!43RltRt Rt Rt Rt Rt R tR tR tR tR tRtRtRtRtVtR#)MultiCellRangei)rc\V\4'd)VP4Uu.uFp\V4NK pp\ V4VnR#uupirK)r<strsplitrsetranges)rrrs&& rrMultiCellRange.__init__s= fc " ",2LLN;NqilNF;&k )joinsortedrrFrGrrrs& rrHMultiCellRange.__repr__sN4;;=9=a3q6=9:4>>**+2fXR88:sAcRPVP4Uu.uFp\V4NK up4pV#uupi)r)rrrrs& rrPMultiCellRange.__str__s3DKKM:MqCFM:; ;s;c*\\V44#rK)rLrr$s&rrMMultiCellRange.__hash__sCIr!c  H\VP\RRRR4R7#)z Return a sorted list of items rrrr)key)rrrr$s&rrMultiCellRange.sorteds!dkkz)Y S\']^^r!c Tp\V\4'd \V4pM!\V\4'g \R4hW 9dVPP V4R#R#)z$ Add a cell coordinate or CellRange zYou can only add CellRangesN)r<rrrraddrrs&& rrMultiCellRange.addsS eS ! !5!BE9--:; ; > KKOOB  r!c(VPV4V#rK)rrr)s&&r__iadd__MultiCellRange.__iadd__s  r!c\V\4'dVPV4pVPVP8H#rK)r<rrFrr@s&&rr_MultiCellRange.__eq__s0 uc " "NN5)E{{ell**r!c W8X*#rKr@s&&rr\MultiCellRange.__ne__s   r!c,\VP4#rK)boolrr$s&r__bool__MultiCellRange.__bool__sDKK  r!c~\V\4'g \V4pVPPV4R#rK)r<rrremovers&&rrMultiCellRange.removes+%++e$E 5!r!c#<"VPFpVxK R#5irKr)rrss& rrMultiCellRange.__iter__s++BHscjVPUu0uFp\V4kK pp\V4#uupirK)rrrrs& rrTMultiCellRange.__copy__s.#';;/;a$q';/f%%0s0rN)rGrrrrrrrrrtrHrPrMrrrr_r\rrrrTrrrs@rrrsd) 4F"e" 9  _   + !!"  &&r!rN)roperatorropenpyxl.descriptorsrropenpyxl.descriptors.sequencer!openpyxl.descriptors.serialisableropenpyxl.utilsr r r r rrrr!rrsB''8:TT TTn W&VW&r!