o {ړZ1@stddlmZmZddlmZddlmZddlmZmZddl 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@s$eZdZdZeddedZeddedZeddedZeddedZ  d4ddZ e d d Z e d d Z d dZddZddZeZddZddZd5ddZddZddZddZeZd d!Zd"d#ZeZd$d%Zd&d'Zd(d)Zd*d+ZeZ d,d-Z!e!Z"d6d.d/Z#d6d0d1Z$e d2d3Z%dS)7 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|dur"z t|\}\}}}}Wnty!t|\}}}}Ynw||_||_||_||_||_||kr@d}t|j||d||krOd}t|j||ddS)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)self range_stringrrrrrfmtrO/var/www/html/env/lib/python3.10/site-packages/openpyxl/worksheet/cell_range.py__init__.s$ zCellRange.__init__cCs|j|j|j|jfS)z2 Vertices of the range as a tuple rrrrrrrrboundsDszCellRange.boundscCsBd}|j|jkr|j|jkrd}|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 rrrrrcoordLs  zCellRange.coordcCs<t|ts ttt||jr|j|jkrtddSdS)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_title^s zCellRange._check_titlecCs*d}|jrd}t|j|jj|j|jdS)Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)clsrr")rrr __class____name__r"r!rrr__repr__kszCellRange.__repr__cCs.d}|j}|jrd}t|j}|j||jdS)Nz{coord}z{title}!{coord})rr")rr rr")rrrrrr_get_range_stringrs  zCellRange._get_range_stringcCs|}t|SN)r.rrr"rrr__str__}szCellRange.__str__cCs|j|j|j|j|j|jdS)Nrrrrr)r+rrrrrrrrr__copy__s zCellRange.__copy__rcCsh|j|dks|j|dkrtd|||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)r col_shift row_shiftrrrshifts zCellRange.shiftcCsTz||Wn tyYdSw|j|jkp)|j|jkp)|j|jkp)|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)rrrrrr'rrr__ne__s     zCellRange.__ne__cCs || S)z Test whether the ranges are equal. :type other: CellRange :param other: Other sheet range :return: ``True`` if *range* == *other*. )r7r'rrr__eq__s zCellRange.__eq__cCs^|||j|jko|jko|jkno.|j|jko,|jko,|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)rrrrr'rrrissubset *"zCellRange.issubsetcC||o ||S)z Test whether every element in the range is in *other*, but not all. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* < *other*. )__le__r7r'rrr__lt__zCellRange.__lt__cCs^|||j|jko|jko|jkno.|j|jko,|jko,|jkSS)a0 Test whether every element in *other* is in the range. :type other: openpyxl.worksheet.cell_range.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*). r9r'rrr issupersetr;zCellRange.issupersetcCs&||}|jdur|j|_||S)zO Check whether the range contains a particular cell coordinate N)r+rr@)rr"crrrr __contains__s   zCellRange.__contains__cCr<)z Test whether every element in *other* is in the range, but not all. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* > *other*. )__ge__r7r'rrr__gt__r?zCellRange.__gt__cCs:|||j|jkr|}|}|}|j|jf|j|jfkS)aY 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: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: `True`` if the range has no elements in common with other. )r)r rrr)rr(irrr isdisjoints zCellRange.isdisjointcCsb||r td||t|j|j}t|j|j}t|j|j}t|j|j}t ||||dS)aY Return a new range with elements common to the range and another :type others: tuple[openpyxl.worksheet.cell_range.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}r) rFrrrrrrrrr rr(rrrrrrr intersections zCellRange.intersectioncCsV||t|j|j}t|j|j}t|j|j}t|j|j}t|||||jdS)z Return a new range with elements from the range and all *others*. :type others: tuple[openpyxl.worksheet.cell_range.CellRange] :param others: Other sheet ranges. :return: the current sheet range. r2) r)rrrrrrr rrGrrrunion/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 Nr)rrightdownleftuprrrexpandD 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 Nr)rrJbottomrLtoprrrshrinkWrOzCellRange.shrinkcCs*|jd|j}|jd|j}||dS)zD Return the size of the range as a dicitionary of rows and columns. r )columnsrows)rrrr)rcolsrTrrrsizejs zCellRange.size)NNNNNN)rr)rrrr)&r, __module__ __qualname____doc__rintrrrrrpropertyr r"r)r-r. __unicode__r1r3r6r7r8r:r=r>r@rCrBrDrFrH__and__rI__or__rNrRrVrrrrr sL           r c@steZdZeedZdddZddZddZd d Z e Z d d Z e Z d dZ ddZddZeZddZddZdS)MultiCellRange)rrcCs&t|trdd|D}||_dS)NcSg|]}t|qSr)r .0rrrr zz+MultiCellRange.__init__..)r#strsplitrangesrrhrrrrxs  zMultiCellRange.__init__cCs|jD] }||vr dSqdS)NTFrh)rr"rcrrrrB~s zMultiCellRange.__contains__cCs&ddd|jD}d|jj|S)N cSr`rrfrarrrrdrez+MultiCellRange.__repr__..z <{0} [{1}]>)joinrhrr+r,rirrrr-szMultiCellRange.__repr__cCsddd|jD}|S)NrkcSr`rrlrarrrrdrez*MultiCellRange.__str__..)rmrhrirrrr1szMultiCellRange.__str__cCs*||vrt|}|j}||||_|S)zD Add a cell coordinate. Will create a new CellRange )r rhappend)rr"rArhrrradds  zMultiCellRange.addcCs t|tr ||}|j|jkSr/)r#rfr+rhr'rrrr8s   zMultiCellRange.__eq__cCs ||k Sr/rr'rrrr7 zMultiCellRange.__ne__cCs t|jSr/)boolrhrrrr__bool__rpzMultiCellRange.__bool__cCs"t|ts t|}|j|dSr/)r#r rhremover0rrrrss zMultiCellRange.removeccs|jD]}|VqdSr/rj)rrArrr__iter__s zMultiCellRange.__iter__N)r)r,rWrXrr rhrrBr-r1r\ro__iadd__r8r7rr __nonzero__rsrtrrrrr_rs    r_N) __future__rropenpyxl.compat.stringsropenpyxl.descriptorsrrropenpyxl.utilsrr r r r r_rrrrs  d