Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/worksheet/__pycache__/cell_range.cpython-37.pyc
Назад
B �5�g�: � @ s� d dl m Z d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d dl m Z m Z m Z mZ G dd � d e �ZG d d � d e�Zd S ) � )�copy)� attrgetter)�Strict)�MinMax)�UniqueSequence)� Serialisable)�range_boundaries�range_to_tuple�get_column_letter�quote_sheetnamec @ s� e Zd ZdZedded�Zedded�Zedded�Zedded�Z dFdd�Z e d d � �Z e d d � �Z e d d� �Ze dd� �Ze dd� �Zdd� Zdd� Zdd� Zdd� Zdd � ZdGd d �Zd d!� Zd"d#� Zd$d%� ZeZd&d'� Zd(d)� Z d*d+� Z e Z d,d-� Z d.d/� Z d0d1� Z!d2d3� Z"e"Z#d4d5� Z$e$Z%d6d7� Z&dHd8d9�Z'dId:d;�Z(e d<d=� �Z)e d>d?� �Z*e d@dA� �Z+e dBdC� �Z,e dDdE� �Z-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 )�min�max� expected_typei Nc C s� |d k r6d|kr&t |�\}\}}}}nt|�\}}}}|| _|| _|| _|| _|| _||krrd}t|j||d���||kr�d}t|j||d���d S )N�!z({max_col} must be greater than {min_col})�min_col�max_colz({max_row} must be greater than {min_row})�min_row�max_row) r r r r r r �title� ValueError�format)�selfZ range_stringr r r r r �fmt� r �S/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/worksheet/cell_range.py�__init__0 s zCellRange.__init__c C s | j | j| j| jfS )z2 Vertices of the range as a tuple )r r r r )r r r r �boundsF s zCellRange.boundsc C sB d}| j | jkr | j| jkr d}|jt| j �| jt| j�| jd�S )z9 Excel-style representation of the range z%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row})r r r r )r r r r r r )r r r r r �coordN s zCellRange.coordc # sB x<t | j| jd �D ]&� � fdd�t | j| jd �D �V qW dS )z1 Return cell coordinates as rows r c s g | ] }� |f�qS r r )�.0�col)�rowr r � <listcomp>e s z"CellRange.rows.<locals>.<listcomp>N)�ranger r r r )r r )r" r �rows_ s zCellRange.rowsc # sB x<t | j| jd �D ]&� � fdd�t | j| jd �D �V qW dS )z4 Return cell coordinates as columns r c s g | ] }|� f�qS r r )r r" )r! r r r# n s z"CellRange.cols.<locals>.<listcomp>N)r$ r r r r )r r )r! r �colsh s zCellRange.colsc C s2 ddl m} |t| j| jd �t| j| jd ��S )Nr )�productr )� itertoolsr' r$ r r r r )r r' r r r �cellsq s zCellRange.cellsc C s8 t |t�sttt|����|jr4| j|jkr4td��dS )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 � TypeError�repr�typer r )r �otherr r r � _check_titlew s zCellRange._check_titlec C s& d}| j rd}|j| jj| j | jd�S )Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)�clsr r )r r � __class__�__name__r )r r r r r �__repr__� s zCellRange.__repr__c C s t | j| j| j| jf�S )N)�hashr r r r )r r r r �__hash__� s zCellRange.__hash__c C s* d}| j }|rd}t|�}|j|| jd�S )Nz{coord}z{title}!{coord})r r )r r r r )r r r r r r �__str__� s zCellRange.__str__c C s | j | j| j| j| j| jd�S )N)r r r r r )r1 r r r r r )r r r r �__copy__� s zCellRange.__copy__r c C sh | 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 r z1Invalid shift value: col_shift={0}, row_shift={1}N)r r r r r r )r Z col_shiftZ row_shiftr r r �shift� s zCellRange.shiftc C sT y| � |� W n tk r" dS X |j| jkpR| j|jkpR|j| jkpR| 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)r/ r r r r r )r r. r r r �__ne__� s zCellRange.__ne__c C s | � |� 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*. )r9 )r r. r r r �__eq__� s zCellRange.__eq__c C s | � |� |�| �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*. )r/ �_CellRange__superset)r r. r r r �issubset� s zCellRange.issubsetc C s | � |�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__r9 )r r. r r r �__lt__� s zCellRange.__lt__c C sT | j |j ko$|j ko$| jkn oR| j|j koN|j koN| jkS S )N)r r r r )r r. r r r Z __superset� s *zCellRange.__supersetc C s | � |� | �|�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/ r; )r r. r r r � issuperset� s zCellRange.issupersetc C s | � |�}| �|�S )zO Check whether the range contains a particular cell coordinate )r1 r; )r r �crr r r � __contains__ s zCellRange.__contains__c C s | � |�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__r9 )r r. r r r �__gt__ s zCellRange.__gt__c C sD | � |� | j|jkr || } }| j|jk pB| j|jk pB|j| jk S )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. )r/ r r r r r )r r. r r r � isdisjoint s zCellRange.isdisjointc C sb | � |�rtd�| |���t| j|j�}t| j|j�}t| j|j�}t| j|j�}t ||||d�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. z Range {0} doesn't intersect {0})r r r r ) rD r r r r r r r r r )r r. r r r r r r r � intersection* s zCellRange.intersectionc C sV | � |� t| j|j�}t| j|j�}t| j|j�}t| j|j�}t||||| jd�S )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*. )r r r r r ) r/ r r r r r r r r )r r. r r r r r r r �unionB s zCellRange.unionc c s2 x,| j D ]"}|dkrqt| |�}||fV qW dS )zC For use as a dictionary elsewhere in the library. r N)� __attrs__�getattr)r �x�vr r r �__iter__X s zCellRange.__iter__c C s< | 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)r r r r )r �rightZdown�left�upr r r �expandc s zCellRange.expandc C s< | 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 N)r r r r )r rL �bottomrM �topr r r �shrinkv s zCellRange.shrinkc C s* | j d | j }| jd | j }||d�S )zC Return the size of the range as a dictionary of rows and columns. r )�columnsr% )r r r r )r r& r% r r r �size� s zCellRange.sizec s � fdd�t � j� jd �D �S )z=A list of cell coordinates that comprise the top of the rangec s g | ]}� j |f�qS r )r )r r! )r r r r# � s z!CellRange.top.<locals>.<listcomp>r )r$ r r )r r )r r rQ � s z CellRange.topc s � fdd�t � j� jd �D �S )z@A list of cell coordinates that comprise the bottom of the rangec s g | ]}� j |f�qS r )r )r r! )r r r r# � s z$CellRange.bottom.<locals>.<listcomp>r )r$ r r )r r )r r rP � s zCellRange.bottomc s � fdd�t � j� jd �D �S )zCA list of cell coordinates that comprise the left-side of the rangec s g | ]}|� j f�qS r )r )r r" )r r r r# � s z"CellRange.left.<locals>.<listcomp>r )r$ r r )r r )r r rM � s zCellRange.leftc s � fdd�t � j� jd �D �S )zDA list of cell coordinates that comprise the right-side of the rangec s g | ]}|� j f�qS r )r )r r" )r r r r# � s z#CellRange.right.<locals>.<listcomp>r )r$ r r )r r )r r rL � s zCellRange.right)NNNNNN)r r )r r r r )r r r r ).r2 � __module__� __qualname__�__doc__r �intr r r r r �propertyr r r% r& r) r/ r3 r5 r6 r7 r8 r9 r: r< r= r> r; r? rB rA rC rD rE �__and__rF �__or__rK rO rR rT rQ rP rM rL r r r r r sR r c @ s� e Zd Zeed�Ze� fdd�Zdd� Zdd� Z dd � Z d d � Z d d � Z dd� Z dd� Zdd� Zdd� Zdd� Zdd� Zdd� Zd d � Zd S ) �MultiCellRange)r c C s* t |t�r dd� |�� D �}t|�| _d S )Nc S s g | ] }t |��qS r )r )r �rr r r r# � s z+MultiCellRange.__init__.<locals>.<listcomp>)r* �str�split�set�ranges)r ra r r r r � s zMultiCellRange.__init__c C s2 t |t�rt|�}x| jD ]}||krdS qW dS )NTF)r* r^ r ra )r r r] r r r rA � s zMultiCellRange.__contains__c C s. d� dd� | �� D ��}d| jj� d|� d�S )N� c S s g | ] }t |��qS r )r^ )r r] r r r r# � s z+MultiCellRange.__repr__.<locals>.<listcomp>�<z [z]>)�join�sortedr1 r2 )r ra r r r r3 � s zMultiCellRange.__repr__c C s d� dd� | �� D ��}|S )Nrb c S s g | ] }t |��qS r )r^ )r r] r r r r# � s z*MultiCellRange.__str__.<locals>.<listcomp>)rd re )r ra r r r r6 � s zMultiCellRange.__str__c C s t t| ��S )N)r4 r^ )r r r r r5 � s zMultiCellRange.__hash__c C s t | jtdddd�d�S )z/ Return a sorted list of items r r r r )�key)re ra r )r r r r re � s zMultiCellRange.sortedc C sB |}t |t�rt|�}nt |t�s*td��|| kr>| j�|� dS )z4 Add a cell coordinate or CellRange zYou can only add CellRangesN)r* r^ r r ra �add)r r r@ r r r rg � s zMultiCellRange.addc C s | � |� | S )N)rg )r r r r r �__iadd__� s zMultiCellRange.__iadd__c C s t |t�r| �|�}| j|jkS )N)r* r^ r1 ra )r r. r r r r: � s zMultiCellRange.__eq__c C s | |k S )Nr )r r. r r r r9 � s zMultiCellRange.__ne__c C s t | j�S )N)�boolra )r r r r �__bool__� s zMultiCellRange.__bool__c C s" t |t�st|�}| j�|� d S )N)r* r ra �remove)r r r r r rk � s zMultiCellRange.removec c s x| j D ] }|V qW d S )N)ra )r r@ r r r rK � s zMultiCellRange.__iter__c C s dd� | j D �}t|�S )Nc S s h | ] }t |��qS r )r )r r] r r r � <setcomp>� s z*MultiCellRange.__copy__.<locals>.<setcomp>)ra r\ )r ra r r r r7 � s zMultiCellRange.__copy__N)r2 rU rV r r ra r` r rA r3 r6 r5 re rg rh r: r9 rj rk rK r7 r r r r r\ � s r\ N)r �operatorr Zopenpyxl.descriptorsr r Z openpyxl.descriptors.sequencer Z!openpyxl.descriptors.serialisabler Zopenpyxl.utilsr r r r r r\ r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка