Mwg:ddlmZddlmZddlmZddlmZddlmZddlm Z ddl m Z m Z m Z mZGdd e ZGd d eZy ) )copy) attrgetter)Strict)MinMax)UniqueSequence) Serialisable)range_boundariesrange_to_tupleget_column_letterquote_sheetnameceZdZdZeddeZeddeZeddeZeddeZ d&dZ e dZ e d Z e d Ze d Ze d Zd ZdZdZdZdZd'dZdZdZdZeZdZdZdZeZdZdZ dZ!dZ"e"Z#dZ$e$Z%dZ&d(dZ'd(d Z(e d!Z)e d"Z*e d#Z+e d$Z,e d%Z-y)) 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*|(d|vrt|\}\}}}}nt|\}}}}||_||_||_||_||_||kDrd}t|j||||kDrd}t|j||y)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 T/var/www/horilla/myenv/lib/python3.12/site-packages/openpyxl/worksheet/cell_range.py__init__zCellRange.__init__0s  #l">L\>Z;;'75El5S2'7     W :E$,,PTP\P\]^P^<_``r!ct|tsttt ||j r%|j |j k7r t dyy)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_titlezCellRange._check_titlewsK %+De-. . ;;4::4PQ Q5;r!cd}|jrd}|j|jj|j|jS)Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)clsrr()rr __class____name__r(r's r__repr__zCellRange.__repr__s:  ::.Czzdnn55TZZtzzzZZr!cpt|j|j|j|jfSN)hashrrrrr$s r__hash__zCellRange.__hash__s&T\\4<<t||LMMr!cvd}|j}|r d}t|}|j||jS)Nz{coord}z{title}!{coord})rr()rr rr()rrrs r__str__zCellRange.__str__s9  $C#E*EzzTZZz88r!c|j|j|j|j|j|j S)Nrrrrr)r@rrrrrr$s r__copy__zCellRange.__copy__s8~~dllDLL&*llDLL$(JJ0 0r!c*|j|zdks|j|zdkrtdj|||xj|z c_|xj|z c_|xj|z c_|xj |z c_y)a{ 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 rshiftzCellRange.shiftsy LL9 $ )||i'1,PWWXaclmn n !  !  !  ! r!c |j||j|jk7xsO|j|jk7xs4|j|jk7xs|j |j k7S#t$rYywxYw)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)r=rrrrrr;s r__ne__zCellRange.__ne__s    e $ MMT\\ ) -||u}}, -}} , -||u}},    sA== B B c&|j| S)z Test whether the ranges are equal. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* == *other*. )rQr;s r__eq__zCellRange.__eq__s;;u%%%r!cF|j||j|S)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*. r=_CellRange__supersetr;s rissubsetzCellRange.issubsets# % %%r!cJ|j|xr|j|S)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__rQr;s r__lt__zCellRange.__lt__!{{5!8dkk%&88r!c|j|jcxkxr!|jcxkxr|jkncxr@|j|jcxkxr!|jcxkxr|jkScSrD)rrrrr;s r __supersetzCellRange.__supersets\ \\U]] Kemm Kt|| K M \\U]] Kemm Kt|| K L r!cF|j||j|S)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*). rUr;s r issupersetzCellRange.issupersets! % u%%r!cF|j|}|j|S)zO Check whether the range contains a particular cell coordinate )r@rVrr(crs r __contains__zCellRange.__contains__s!^^E "r""r!cJ|j|xr|j|S)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__rQr;s r__gt__zCellRange.__gt__ r[r!c|j||j|jkDr||}}|j|jkxs4|j|j kxs|j|j kS)aV 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. )r=r%rrrrr;s r isdisjointzCellRange.isdisjointsl %  ;; %%D u}},0<<%--/0==4<</ 1r!cx|j|rtdj||t|j|j}t |j |j }t|j|j}t |j|j}t||||S)aN 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#) rhrrrrrrrrrrr<rrrrs r intersectionzCellRange.intersection*s ??5 !>EEdERS SdllEMM2dllEMM2dllEMM2dllEMM2'7!(* *r!cX|j|t|j|j}t|j|j}t|j |j }t|j |j }t|||||jS)a 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*. rJ) r=rrrrrrrrrjs runionzCellRange.unionBs~ % dllEMM2dllEMM2dllEMM2dllEMM2'7!( < /RSs#SSS>ct|j|jdzDcgc]}|j|fc}Scc}w)z@A list of cell coordinates that comprise the bottom of the ranger)r*rrrrs rr{zCellRange.bottomrrct|j|jdzDcgc]}||jfc}Scc}w)zCA list of cell coordinates that comprise the left-side of the ranger)r*rrrrr+s rrwzCellRange.left505T\\4</RSdll#SSSrct|j|jdzDcgc]}||jfc}Scc}w)zDA list of cell coordinates that comprise the right-side of the ranger)r*rrrrs rruzCellRange.rightrr)NNNNNN)rr)rrrr).rA __module__ __qualname____doc__rintrrrrr propertyr%r(r-r1r5r=rBrFrHrKrOrQrSrWrYrZrVr_rercrfrhrk__and__rm__or__rsryr}rr|r{rwrur!rrrs.S9Gs;GS9Gs;GAE37K,FF  NNNNaa R[N90 "( *& &F9  &F#91(**G<&F&&--TT TT TT TTr!rceZdZeeZefdZdZdZ dZ dZ dZ dZ d Zd Zd Zd Zd ZdZdZy)MultiCellRange)rct|tr&|jDcgc] }t|}}t ||_ycc}wrD)r7strsplitrsetranges)rrrs rr zMultiCellRange.__init__s9 fc ",2LLN;qil;F;&k )joinsortedrr@rArrrs rrBzMultiCellRange.__repr__sJ4;;=9a3q69:4>>**+2fXR88:sAc|dj|jDcgc] }t|c}}|Scc}w)Nr)rrrrs rrHzMultiCellRange.__str__s/DKKM:qCF:; ;s9c*tt|SrD)rErr$s rrFzMultiCellRange.__hash__sCIr!c Ht|jtddddS)z/ Return a sorted list of items rrrr)key)rrrr$s rrzMultiCellRange.sorteds!dkkz)Y S\']^^r!c|}t|tr t|}nt|ts td||vr|jj |yy)z4 Add a cell coordinate or CellRange zYou can only add CellRangesN)r7rrrraddras rrzMultiCellRange.addsO eS !5!BE9-:; ; T> KKOOB  r!c(|j||SrD)rrr(s r__iadd__zMultiCellRange.__iadd__s  r!cvt|tr|j|}|j|jk(SrD)r7rr@rr;s rrSzMultiCellRange.__eq__s- uc "NN5)E{{ell**r!c||k( SrDrr;s rrQzMultiCellRange.__ne__s5=  r!c,t|jSrD)boolrr$s r__bool__zMultiCellRange.__bool__sDKK  r!cpt|ts t|}|jj|yrD)r7rrremovers rrzMultiCellRange.removes(%+e$E 5!r!c#6K|jD]}|ywrD)r)rrbs rrszMultiCellRange.__iter__s++ BH scf|jDchc] }t|}}t|Scc}wrD)rrrrs rrKzMultiCellRange.__copy__s-#';;/a$q'//f%%0s.N)rArrrrrrr rcrBrHrFrrrrSrQrrrsrKrr!rrrs\) 4F"e" 9  _   + !!"  &r!rN)roperatorropenpyxl.descriptorsrropenpyxl.descriptors.sequencer!openpyxl.descriptors.serialisableropenpyxl.utilsr r r r rrrr!rrsB''8:TT TTn W&VW&r!