^b29ddlmZddlmZddlmZmZddlmZddlmZm Z m Z m Z GddeZ Gdd eZ d S) )copy)Strict)MinMaxSequence) Serialisable)range_boundariesrange_to_tupleget_column_letterquote_sheetnameceZdZdZeddeZeddeZeddeZeddeZ d&dZ e dZ e d Z e d Ze d Ze d Zd ZdZdZdZd'dZdZdZdZeZdZdZdZeZdZdZdZ 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,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 rrrrrtitle ValueErrorformat)self range_stringrrrrrfmts =lib/python3.11/site-packages/openpyxl/worksheet/cell_range.py__init__zCellRange.__init__/s  Tl" T>L\>Z>Z;;'775El5S5S2'7     W  Kz"CellRange.rows..dMMM#C:MMMr N)rangerrrr)rr-s @rrowszCellRange.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 rr.z"CellRange.cols..mr/r N)r0rrrr)rr,s @rcolszCellRange.colsgr2r cddlm}|t|j|jdzt|j|jdzS)Nr)productr) itertoolsr7r0rrrr)rr7s rcellszCellRange.cellspsN%%%%%%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_titlevsu %++ /De--.. . ; R4:4 RPQQ Q R R R Rr 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 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)rDrrrrrr#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 rshiftzCellRange.shifts L9 $ ) o|i'1, oPWWXaclmmnn 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)rArrrrrr?s 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*. )rQr?s 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*. rA_CellRange__supersetr?s rissubsetzCellRange.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__rQr?s r__lt__zCellRange.__lt__'{{5!!8dkk%&8&88r c|j|jcxko|jcxko |jknco*|j|jcxko|jcxko |jkncSN)rrrrr?s 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*). rUr?s r issupersetzCellRange.issupersets* %   u%%%r cV||}||S)zO Check whether the range contains a particular cell coordinate )rDrVrr'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__rQr?s r__gt__zCellRange.__gt__r[r 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. )rAr$rrrrr?s r isdisjointzCellRange.isdisjointsg %    ; % &%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") rirrrrrrrrr rr@rrrrs 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*. rJ) rArrrrrrr rrks runionzCellRange.union=s %   dlEM22dlEM22dlEM22dlEM22'7!( <<< . SSSs#SSSr rr0rrr#s`rr}z CellRange.top3TSSSuT\4/R/RSSSSr cVfdtjjdzDS)z@A list of cell coordinates that comprise the bottom of the rangec"g|] }j|f Sr*)rrs rr.z$CellRange.bottom..rr rrr#s`rr|zCellRange.bottomrr cVfdtjjdzDS)zCA list of cell coordinates that comprise the left-side of the rangec"g|] }|jf Sr*)rr+r-rs rr.z"CellRange.left.. SSSdl#SSSr rr0rrr#s`rrxzCellRange.leftrr cVfdtjjdzDS)zDA list of cell coordinates that comprise the right-side of the rangec"g|] }|jf Sr*)rrs rr.z#CellRange.right..rr rrr#s`rrvzCellRange.rightrr )NNNNNN)rr)rrrr)-rE __module__ __qualname____doc__rintrrrrrpropertyr$r'r1r5r9rArFrHrKrOrQrSrWrYrZrVr`rfrdrgrirl__and__rn__or__rtrzr~rr}r|rxrvr*r rr r s.fS999Gfs;;;GfS999Gfs;;;GAE37KKKK,FFXF  X NNXNNNXNaaXa R R R[[[999000 """"(   *&&& & & &F999    & & &F###999111(****G<<<&F&&--X-TTXT TTXT TTXT TTXTTTr r cteZdZeeZddZdZdZdZ e Z dZ dZ d Z d Z d Zd Zd ZdZdS)MultiCellRange)rr*czt|trd|D}||_dS)Nc,g|]}t|Sr*)r r+rs rr.z+MultiCellRange.__init__..s;;;qill;;;r )r;strsplitrangesrrs rrzMultiCellRange.__init__s: fc " " <;;FLLNN;;;F r ctt|trt|}|jD] }||krdS dS)NTF)r;rr r)rr'rs rrdzMultiCellRange.__contains__sO eS ! ! %e$$E  Az tt ur cdd|jD}d|jj|S)N c,g|]}t|Sr*rrs rr.z+MultiCellRange.__repr__..s777a3q66777r z <{0} [{1}]>)joinrrrDrErs rrFzMultiCellRange.__repr__s?774;77788##DN$;VDDDr cNdd|jD}|S)Nrc,g|]}t|Sr*rrs rr.z*MultiCellRange.__str__..s888qCFF888r )rrrs rrHzMultiCellRange.__str__s)88DK88899 r c|}t|trt|}n$t|tstd||vr|j|dSdS)z4 Add a cell coordinate or CellRange zYou can only add CellRangesN)r;rr rrappendrbs raddzMultiCellRange.adds} eS ! ! <5!!BBE9-- <:;; ; T> # K  r " " " " " # #r c0|||Sr])rrr's r__iadd__zMultiCellRange.__iadd__s  r cvt|tr||}|j|jkSr])r;rrDrr?s rrSzMultiCellRange.__eq__s4 uc " " *NN5))E{el**r c||k Sr]r*r?s rrQzMultiCellRange.__ne__s5=  r c*t|jSr])boolrr#s r__bool__zMultiCellRange.__bool__sDK   r ct|tst|}|j|dSr])r;r rremovers rrzMultiCellRange.removes=%++ %e$$E 5!!!!!r c#&K|jD]}|VdSr])r)rrcs rrtzMultiCellRange.__iter__s,+  BHHHH  r ct}|jD])}|jt|*|Sr])rrrr)rnrs rrKzMultiCellRange.__copy__s@    % %A HOODGG $ $ $ $r N)r*)rErrrr rrrdrFrHrrrSrQrrrtrKr*r rrrsXI . . .F EEE G # # # +++ !!!!!!"""  r rN)ropenpyxl.descriptorsrrr!openpyxl.descriptors.serialisableropenpyxl.utilsrr r r r rr*r rrs ''''''11111111::::::PTPTPTPTPT PTPTPTf QQQQQVQQQQQr