fh:ddlmZddlmZddlmZddlmZddlmZddlm Z ddl m Z m Z m Z mZGdd e ZGd d eZd S) 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)d Z'd)d!Z(e d"Z)e d#Z*e d$Z+e d%Z,e d&Z-dS)* 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`|0d|vrt|\}\}}}}nt|\}}}}||_||_||_||_||_||kr&d}t|||||kr&d}t|||dS)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/histauto/venv/lib/python3.11/site-packages/openpyxl/worksheet/cell_range.py__init__zCellRange.__init__0s  #l"">L\>Z>Z;;'775El5S5S2'7     W  z"CellRange.rows..eMMM#C:MMMr"N)rangerrrr)rr/s @r rowszCellRange.rows_m t|A~66 N NCMMMMt|T\!^)L)LMMM M M M M N Nr"c#Kt|j|jdzD]-fdt|j|jdzDV.dS)z4 Return cell coordinates as columns rcg|]}|fSr,r,)r-r/r.s r r0z"CellRange.cols..nr1r"N)r2rrrr)rr.s @r colszCellRange.colshr4r"cddlm}|t|j|jdzt|j|jdzS)Nr)productr) itertoolsr9r2rrrr)rr9s r cellszCellRange.cellsqsN%%%%%%wuT\4<>::E$,PTP\]^P^<_<_```r"ct|ts)ttt ||jr|j|jkrt ddSdS)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_titlewsl %++ /De--.. . ; R4:44PQQ Q R R44r"cpd}|jrd}||jj|j|jS)Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)clsrr))rr __class____name__r)r(s r __repr__zCellRange.__repr__s7  : /.Czzdn5TZtzzZZZr"cPt|j|j|j|jfSN)hashrrrrr%s r __hash__zCellRange.__hash__s!T\4<t|LMMMr"crd}|j}|rd}t|}|||jS)Nz{coord}z{title}!{coord})rr))rr rr))rrrs r __str__zCellRange.__str__s@   +$C#E**EzzTZz888r"ch||j|j|j|j|jS)Nrrrrr)rFrrrrrr%s r __copy__zCellRange.__copy__s3~~dlDL&*lDL$(J00 0r"rc|j|zdks|j|zdkr#td|||xj|z c_|xj|z c_|xj|z c_|xj|z c_dS)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 r shiftzCellRange.shifts L9 $ ) )|i'1,,PWWXaclmmnn n !  !  !  ! r"c ||n#t$rYdSwxYw|j|jkp/|j|jkp|j|jkp|j|jkS)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)rCrrrrrrAs r __ne__zCellRange.__ne__s    e $ $ $ $   44  MT\ ) -|u}, -} , -|u},  s  &&c.|| 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*. )rWrAs r __eq__zCellRange.__eq__s;;u%%%%r"cV||||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*. rC_CellRange__supersetrAs r issubsetzCellRange.issubsets, %   %%%r"cV||o||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__rWrAs r __lt__zCellRange.__lt__'{{5!!8dkk%&8&88r"c|j|jcxko|jcxko |jknco*|j|jcxko|jcxko |jkncSrJ)rrrrrAs r __supersetzCellRange.__supersetsw \U] K K K Kem K K K Kt| K K K K M \U] K K K Kem K K K Kt| K K K K r"cV||||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*). r[rAs r issupersetzCellRange.issupersets* %   u%%%r"cV||}||S)zO Check whether the range contains a particular cell coordinate )rFr\rr)crs r __contains__zCellRange.__contains__s'^^E " "r"""r"cV||o||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__rWrAs r __gt__zCellRange.__gt__ rar"c|||j|jkr||}}|j|jkp|j|jkp|j|jkS)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. )rCr&rrrrrAs r isdisjointzCellRange.isdisjointse %    ; % %%D u},0<%-/0=4</ 1r"ch||r#td||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$) rnrrrrrrrrrrrBrrrrs r intersectionzCellRange.intersection*s ??5 ! ! T>EEdERRSS SdlEM22dlEM22dlEM22dlEM22'7!(*** *r"c.||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*. rP) rCrrrrrrrrrps r unionzCellRange.unionBs %   dlEM22dlEM22dlEM22dlEM22'7!( <<< . SSSs#SSSr"rr2rrr%s`r rz CellRange.top3TSSSuT\4/R/RSSSSr"cVfdtjjdzDS)z@A list of cell coordinates that comprise the bottom of the rangec"g|] }j|f Sr,)rrs r r0z$CellRange.bottom..rr"rrr%s`r rzCellRange.bottomrr"cVfdtjjdzDS)zCA list of cell coordinates that comprise the left-side of the rangec"g|] }|jf Sr,)rr-r/rs r r0z"CellRange.left.. SSSdl#SSSr"rr2rrr%s`r r}zCellRange.leftrr"cVfdtjjdzDS)zDA list of cell coordinates that comprise the right-side of the rangec"g|] }|jf Sr,)rrs r r0z#CellRange.right..rr"rrr%s`r r{zCellRange.rightrr")NNNNNN)rr)rrrr).rG __module__ __qualname____doc__rintrrrrr!propertyr&r)r3r7r;rCrHrLrNrQrUrWrYr]r_r`r\rerkrirlrnrq__and__rs__or__ryrrrrrr}r{r,r"r rrs".fS999Gfs;;;GfS999Gfs;;;GAE37KKKK,FFXF  X NNXNNNXNaaXa R R R[[[NNN999000 """"(   *&&& & & &F999    & & &F###999111(****G<<<&F&&--X-TTXT TTXT TTXT TTXTTTr"rceZdZeeZefdZdZdZ dZ dZ dZ dZ d Zd Zd Zd Zd ZdZdZdS)MultiCellRange)rct|trd|D}t||_dS)Nc,g|]}t|Sr,)rr-rs r r0z+MultiCellRange.__init__..s;;;qill;;;r")r=strsplitsetrangesrrs r r!zMultiCellRange.__init__s@ fc " " <;;FLLNN;;;F&kk r"ctt|trt|}|jD] }||krdS dS)NTF)r=rrr)rr)rs r rizMultiCellRange.__contains__sL eS ! ! %e$$E  Azzttur"cdd|D}d|jjd|dS)N c,g|]}t|Sr,rrs r r0z+MultiCellRange.__repr__..s999a3q66999r")joinsortedrFrGrs r rHzMultiCellRange.__repr__sH994;;==999::84>*88f8888r"chdd|D}|S)Nrc,g|]}t|Sr,rrs r r0z*MultiCellRange.__str__..s:::qCFF:::r")rrrs r rNzMultiCellRange.__str__s/::DKKMM:::;; r"c:tt|SrJ)rKrr%s r rLzMultiCellRange.__hash__sCIIr"c Nt|jtddddS)z/ Return a sorted list of items rrrr)key)rrrr%s r rzMultiCellRange.sorteds(dkz)Y S\']']^^^^r"c|}t|trt|}n$t|tstd||vr|j|dSdS)z4 Add a cell coordinate or CellRange zYou can only add CellRangesN)r=rrrraddrgs r rzMultiCellRange.addsu eS ! ! <5!!BBE9-- <:;; ; T>> KOOB      >r"c0|||SrJ)rrr)s r __iadd__zMultiCellRange.__iadd__s  r"cvt|tr||}|j|jkSrJ)r=rrFrrAs r rYzMultiCellRange.__eq__s4 uc " " *NN5))E{el**r"c||k SrJr,rAs r rWzMultiCellRange.__ne__s5=  r"c*t|jSrJ)boolrr%s r __bool__zMultiCellRange.__bool__sDK   r"ct|tst|}|j|dSrJ)r=rrremovers r rzMultiCellRange.removes=%++ %e$$E 5!!!!!r"c#&K|jD]}|VdSrJ)r)rrhs r ryzMultiCellRange.__iter__s,+  BHHHH  r"cBd|jD}t|S)Nc,h|]}t|Sr,rrs r z*MultiCellRange.__copy__..s///a$q''///r")rrrs r rQzMultiCellRange.__copy__s%//4;///f%%%r"N)rGrrrrrrr!rirHrNrLrrrrYrWrrryrQr,r"r rrs ^) 4 4 4F"cee"""" 999  ___     +++ !!!!!!"""  &&&&&r"rN)roperatorropenpyxl.descriptorsrropenpyxl.descriptors.sequencer!openpyxl.descriptors.serialisabler openpyxl.utilsr r r r rrr,r"r rs(''''''''''''888888::::::TTTTTTTTTT TTTTTTn W&W&W&W&W&VW&W&W&W&W&r"