U rηh:@sddlmZddlmZddlmZddlmZddlmZddlm Z ddl m Z m Z m Z mZGdd d e ZGd d d eZd S) copy) attrgetter)Strict)MinMax)UniqueSequence) Serialisable)range_boundariesrange_to_tupleget_column_letterquote_sheetnamec@seZdZdZeddedZeddedZeddedZeddedZ dFddZ e d d Z e d d Z e d dZe ddZe ddZddZddZddZddZddZdGddZd d!Zd"d#Zd$d%ZeZd&d'Zd(d)Zd*d+ZeZd,d-Zd.d/Z d0d1Z!d2d3Z"e"Z#d4d5Z$e$Z%d6d7Z&dHd8d9Z'dId:d;Z(e dd?Z*e d@dAZ+e dBdCZ,e dDdEZ-dS)J 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_typeiNcCs|dk r6d|kr&t|\}\}}}}nt|\}}}}||_||_||_||_||_||krrd}t|j||d||krd}t|j||ddS)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)selfZ range_stringrrrrrfmtrA/tmp/pip-unpacked-wheel-49e_hfpc/openpyxl/worksheet/cell_range.py__init__0szCellRange.__init__cCs|j|j|j|jfS)z2 Vertices of the range as a tuple rrrrrrrrboundsFszCellRange.boundscCsBd}|j|jkr |j|jkr d}|jt|j|jt|j|jdS)z9 Excel-style representation of the range z%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}r)rrrrrr rrrrrcoordNs  zCellRange.coordc#s>t|j|jdD]&fddt|j|jdDVqdS)z1 Return cell coordinates as rows rcsg|] }|fqSrr.0colrowrr esz"CellRange.rows..N)rangerrrrr rr'rrows_szCellRange.rowsc#s>t|j|jdD]&fddt|j|jdDVqdS)z4 Return cell coordinates as columns rcsg|] }|fqSrrr%r(r&rrr)nsz"CellRange.cols..N)r*rrrrr rr-rcolshszCellRange.colscCs2ddlm}|t|j|jdt|j|jdS)Nr)productr) itertoolsr/r*rrrr)rr/rrrcellsqs zCellRange.cellscCs8t|tsttt||jr4|j|jkr4tddS)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 TypeErrorreprtyperrrotherrrr _check_titlews zCellRange._check_titlecCs&d}|jrd}|j|jj|j|jdS)Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)clsrr#)rr __class____name__r#r"rrr__repr__szCellRange.__repr__cCst|j|j|j|jfSN)hashrrrrr rrr__hash__szCellRange.__hash__cCs*d}|j}|rd}t|}|j||jdS)Nz{coord}z{title}!{coord})rr#)rr rr#)rrrrrr__str__s zCellRange.__str__cCs|j|j|j|j|j|jdS)Nrrrrr)r:rrrrrr rrr__copy__s  zCellRange.__copy__rcCsh|j|dks|j|dkr,td|||j|7_|j|7_|j|7_|j|7_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)rZ col_shiftZ row_shiftrrrshifts  zCellRange.shiftcCsVz||Wntk r$YdSX|j|jkpT|j|jkpT|j|jkpT|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)r8rrrrrr6rrr__ne__s    zCellRange.__ne__cCs || 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*. )rDr6rrr__eq__szCellRange.__eq__cCs||||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*. r8_CellRange__supersetr6rrrissubsets zCellRange.issubsetcCs||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__rDr6rrr__lt__szCellRange.__lt__cCsT|j|jko$|jko$|jknoR|j|jkoN|jkoN|jkSSr=)rrrrr6rrrZ __supersets*(zCellRange.__supersetcCs||||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*). rFr6rrr issupersets zCellRange.issupersetcCs||}||S)zO Check whether the range contains a particular cell coordinate )r:rGrr#crrrr __contains__s zCellRange.__contains__cCs||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__rDr6rrr__gt__ szCellRange.__gt__cCsD|||j|jkr ||}}|j|jkpB|j|jkpB|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. )r8r!rrrrr6rrr isdisjoints      zCellRange.isdisjointcCsb||rtd||t|j|j}t|j|j}t|j|j}t|j|j}t ||||dS)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) rQrrrrrrrrr rr7rrrrrrr intersection*s zCellRange.intersectioncCsV||t|j|j}t|j|j}t|j|j}t|j|j}t|||||jdS)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*. rA) r8rrrrrrr rrRrrrunionBs zCellRange.unionccs.|jD]"}|dkrqt||}||fVqdS)zC For use as a dictionary elsewhere in the library. rN) __attrs__getattr)rxvrrr__iter__Xs   zCellRange.__iter__cCs<|j|8_|j|8_|j|7_|j|7_dS)a Expand the range by the dimensions provided. :type right: int :param right: expand range to the right by this number of cells :type down: int :param down: expand range down by this number of cells :type left: int :param left: expand range to the left by this number of cells :type up: int :param up: expand range up by this number of cells Nr)rrightZdownleftZuprrrexpandcs zCellRange.expandcCs<|j|7_|j|7_|j|8_|j|8_dS)a Shrink the range by the dimensions provided. :type right: int :param right: shrink range from the right by this number of cells :type down: int :param down: shrink range from the top by this number of cells :type left: int :param left: shrink range from the left by this number of cells :type up: int :param up: shrink range from the bottom by this number of cells Nr)rrZbottomr[toprrrshrinkvs zCellRange.shrinkcCs*|jd|j}|jd|j}||dS)zC Return the size of the range as a dictionary of rows and columns. r)columnsr+)rrrr)rr.r+rrrsizeszCellRange.sizecs fddtjjdDS)z=A list of cell coordinates that comprise the top of the rangecsg|]}j|fqSr)rr$r rrr)sz!CellRange.top..rr*rrr rr rr^sz CellRange.topcs fddtjjdDS)z@A list of cell coordinates that comprise the bottom of the rangecsg|]}j|fqSr)rr$r rrr)sz$CellRange.bottom..rrbr rr rr]szCellRange.bottomcs fddtjjdDS)zCA list of cell coordinates that comprise the left-side of the rangecsg|]}|jfqSr)rr,r rrr)sz"CellRange.left..rr*rrr rr rr[szCellRange.leftcs fddtjjdDS)zDA list of cell coordinates that comprise the right-side of the rangecsg|]}|jfqSr)rr,r rrr)sz#CellRange.right..rrcr rr rrZszCellRange.right)NNNNNN)rr)rrrr)rrrr).r; __module__ __qualname____doc__rintrrrrrpropertyr!r#r+r.r1r8r<r?r@rBrCrDrErHrIrJrGrKrOrNrPrQrS__and__rT__or__rYr\r_rar^r]r[rZrrrrr sl                    r c@seZdZeedZefddZddZddZ dd Z d d Z d d Z ddZ ddZddZddZddZddZddZddZdS)MultiCellRange)rcCs*t|trdd|D}t||_dS)NcSsg|] }t|qSr)r r%rrrrr)sz+MultiCellRange.__init__..)r2strsplitsetrangesrrqrrrrs zMultiCellRange.__init__cCs0t|trt|}|jD]}||krdSqdS)NTF)r2rnr rq)rr#rmrrrrNs   zMultiCellRange.__contains__cCs.ddd|D}d|jjd|dS)N cSsg|] }t|qSrrnrlrrrr)sz+MultiCellRange.__repr__..)joinsortedr:r;rrrrrr<szMultiCellRange.__repr__cCsddd|D}|S)NrscSsg|] }t|qSrrtrlrrrr)sz*MultiCellRange.__str__..)rvrwrrrrrr@szMultiCellRange.__str__cCs tt|Sr=)r>rnr rrrr?szMultiCellRange.__hash__cCst|jtdddddS)z/ Return a sorted list of items rrrr)key)rwrqrr rrrrwszMultiCellRange.sortedcCsB|}t|trt|}nt|ts*td||kr>|j|dS)z4 Add a cell coordinate or CellRange zYou can only add CellRangesN)r2rnr rrqaddrLrrrrys   zMultiCellRange.addcCs|||Sr=)ryrr#rrr__iadd__s zMultiCellRange.__iadd__cCs t|tr||}|j|jkSr=)r2rnr:rqr6rrrrEs  zMultiCellRange.__eq__cCs ||k Sr=rr6rrrrDszMultiCellRange.__ne__cCs t|jSr=)boolrqr rrr__bool__szMultiCellRange.__bool__cCs"t|tst|}|j|dSr=)r2r rqremoverzrrrr~s zMultiCellRange.removeccs|jD] }|VqdSr=)rq)rrMrrrrYs zMultiCellRange.__iter__cCsdd|jD}t|S)NcSsh|] }t|qSrrrlrrr sz*MultiCellRange.__copy__..)rqrkrrrrrrBszMultiCellRange.__copy__N)r;rdrerr rqrprrNr<r@r?rwryr{rErDr}r~rYrBrrrrrks   rkN)roperatorrZopenpyxl.descriptorsrrZopenpyxl.descriptors.sequencerZ!openpyxl.descriptors.serialisablerZopenpyxl.utilsr r r r r rkrrrrs