^Q\"1@sddlmZmZddlmZddlmZddlmZmZddl m Z m Z m Z m Z GdddeZGdd d eZd S) )absolute_importunicode_literals) safe_repr)Strict)MinMaxSequence)range_boundariesrange_to_tupleget_column_letterquote_sheetnamec@seZdZdZedddddeZedddddeZedddddeZedddddeZ ddddddd d Z e d d Z e d dZ ddZddZddZeZddZddZddddZddZddZd d!ZeZd"d#Zd$d%ZeZd&d'Zd(d)Zd*d+Zd,d-ZeZ d.d/Z!e!Z"ddddd0d1Z#ddddd2d3Z$e d4d5Z%dS)6 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, minmaxifG expected_typeiNcCs|dk r^y"t|\}\}}}}Wq^tk rZt|\}}}}Yq^Xn||_||_||_||_||_||krd}t|jd|d|n||krd}t|jd|d|ndS)Nz({max_col} must be greater than {min_col}min_colmax_colz({max_row} must be greater than {min_row}min_rowmax_row) r ValueErrorrrrrrtitleformat)selfZ range_stringrrrrrfmtrR/var/www/dbchiro/venv/lib/python3.4/site-packages/openpyxl/worksheet/cell_range.py__init__.s  "        ! zCellRange.__init__cCs|j|j|j|jfS)z2 Vertices of the range as a tuple )rrrr)rrrrboundsDszCellRange.boundsc Csmd}|j|jkr3|j|jkr3d}n|jdt|jd|jdt|jd|jS)z9 Excel style representation of the range z%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}rrrr)rrrrrr )rrrrrcoordLs   zCellRange.coordcCsXt|ts*ttt|n|jrT|j|jkrTtdndS)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 TypeErrorreprtyperr)rotherrrr _check_title^szCellRange._check_titlecCsFd}|jrd}nt|jd|jjd|jd|jS)Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>clsrr)rrr __class____name__r)rrrrr__repr__ks  zCellRange.__repr__cCsId}|j}|jr0d}t|j}n|jd|d|jS)Nz{coord}z{title}!{coord}rr)rr rr)rrrrrr_get_range_stringrs   zCellRange._get_range_stringcCs|j}t|S)N)r)r)rrrrr__str__}s zCellRange.__str__c Cs7|jd|jd|jd|jd|jd|jS)Nrrrrr)r&rrrrr)rrrr__copy__szCellRange.__copy__rcCs|j|dks&|j|dkrAtdj||n|j|7_|j|7_|j|7_|j|7_dS)an Shift 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.shiftc Cspy|j|Wntk r)dSYnX|j|jkpo|j|jkpo|j|jkpo|j|jkS)z Test whether the ranges are not equal. :type other: CellRange :param other: Other sheet range :return: ``True`` if *range* != *other*. T)r$rrrrr)rr#rrr__ne__s  zCellRange.__ne__cCs|j| S)z Test whether the ranges are equal. :type other: CellRange :param other: Other sheet range :return: ``True`` if *range* == *other*. )r-)rr#rrr__eq__szCellRange.__eq__cCso|j||j|jko;|jko;|jknon|j|jkol|jkol|jkSS)z Test whether every element in the range is in *other*. :type other: SheetRange :param other: Other sheet range :return: ``True`` if *range* <= *other*. )r$rrrr)rr#rrrissubsets 3zCellRange.issubsetcCs|j|o|j|S)z Test whether every element in the range is in *other*, but not all. :type other: CellRange :param other: Other sheet range :return: ``True`` if *range* < *other*. )__le__r-)rr#rrr__lt__szCellRange.__lt__cCso|j||j|jko;|jko;|jknon|j|jkol|jkol|jkSS)a Test whether every element in *other* is in the range. :type other: CellRange or tuple[int, int] :param other: Other sheet range or cell index (*row_idx*, *col_idx*). :return: ``True`` if *range* >= *other* (or *other* in *range*). )r$rrrr)rr#rrr issupersets 3zCellRange.issupersetcCs:|j|}|jdkr-|j|_n|j|S)zO Check whether the range contains a particular cell coordinate N)r&rr2)rrcrrrr __contains__szCellRange.__contains__cCs|j|o|j|S)z Test whether every element in *other* is in the range, but not all. :type other: CellRange :param other: Other sheet range :return: ``True`` if *range* > *other*. )__ge__r-)rr#rrr__gt__szCellRange.__gt__cCsV|j||j|jkr4|}|}|}n|j|jf|j|jfkS)a; Return ``True`` if the range has no elements in common with other. Ranges are disjoint if and only if their intersection is the empty range. :type other: CellRange :param other: Other sheet range. :return: `True`` if the range has no elements in common with other. )r$rrrr)rr#irrr isdisjoints  zCellRange.isdisjointc Cs|j|r*tdj||nt|j|j}t|j|j}t|j|j}t|j|j}t d|d|d|d|S)a; Return a new range with elements common to the range and another :type others: tuple[CellRange] :param others: Other sheet ranges. :return: the current sheet range. :raise: :class:`ValueError` if an *other* range don't intersect with the current range. zRange {0} don't intersect {0}rrrr) r8rrrrr rrrr )rr#rrrrrrr intersections zCellRange.intersectionc Cs|j|t|j|j}t|j|j}t|j|j}t|j|j}td|d|d|d|d|jS)z Return a new range with elements from the range and all *others*. :type others: tuple[CellRange] :param others: Other sheet ranges. :return: the current sheet range. rrrrr) r$r rrrrrr r)rr#rrrrrrrunion/s zCellRange.unioncCs@|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 N)rrrr)rrightZdownleftZuprrrexpandDs 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 bottown by this number of cells N)rrrr)rr;Zbottomr<toprrrshrinkWs zCellRange.shrinkcCs:|jd|j}|jd|j}i|d6|d6S)zD Return the size of the range as a dicitionary of rows and columns. rcolumnsrows)rrrr)rcolsrArrrsizejszCellRange.size)&r' __module__ __qualname____doc__rintrrrrrpropertyrrr$r(r) __unicode__r*r+r,r-r.r/r0r1r2r5r4r6r8r9__and__r:__or__r=r?rCrrrrr sB            r c@seZdZedeZfddZddZddZdd Z e Z d d Z e Z d d Z ddZddZeZddZddZdS)MultiCellRangercCs8t|tr+dd|jD}n||_dS)NcSsg|]}t|qSr)r ).0rrrr zs z+MultiCellRange.__init__..)rstrsplitranges)rrRrrrrxszMultiCellRange.__init__cCs(x!|jD]}||kr dSq WdS)NTF)rR)rrrNrrrr4~s zMultiCellRange.__contains__cCs5djdd|jD}dj|jj|S)N cSsg|]}t|qSr)rP)rMrNrrrrOs z+MultiCellRange.__repr__..z <{0} [{1}]>)joinrRrr&r')rrRrrrr(szMultiCellRange.__repr__cCs#djdd|jD}|S)NrScSsg|]}t|qSr)rP)rMrNrrrrOs z*MultiCellRange.__str__..)rTrR)rrRrrrr*szMultiCellRange.__str__cCs>||kr:t|}|j}|j|||_n|S)zD Add a cell coordinate. Will create a new CellRange )r rRappend)rrr3rRrrradds      zMultiCellRange.addcCs1t|tr!|j|}n|j|jkS)N)rrPr&rR)rr#rrrr.szMultiCellRange.__eq__cCs ||k S)Nr)rr#rrrr-szMultiCellRange.__ne__cCs t|jS)N)boolrR)rrrr__bool__szMultiCellRange.__bool__cCs2t|tst|}n|jj|dS)N)rr rRremove)rrrrrrYszMultiCellRange.removeccsx|jD] }|Vq WdS)N)rR)rr3rrr__iter__szMultiCellRange.__iter__N)r'rDrErr rRrr4r(r*rIrV__iadd__r.r-rXZ __nonzero__rYrZrrrrrLrs         rLN) __future__rrZopenpyxl.compat.stringsrZopenpyxl.descriptorsrrrZopenpyxl.utilsrr r r r rLrrrrs"c