Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/worksheet/__pycache__/datavalidation.cpython-37.pyc
Назад
B �5�g � @ s� d dl mZ d dlmZ d dlmZ d dlmZ d dlm Z m Z m Z m Z m Z mZmZ d dlmZ d dlmZmZmZ dd d �Zd d � Zd dlmZ G dd� de�ZG dd� de�ZdS )� )� defaultdict)�chain)� itemgetter)� Serialisable)�Bool�NoneSet�String�Sequence�Alias�Integer� Convertible)� NestedText)�rows_from_range�coordinate_to_tuple�get_column_letter� c C s� t |�}dd� | D �}tt �}x*t|td�d�D ]\}}|| �|� q0W xR|�� D ]F\}} t|�}d}t| �dkrxd}|�|t | �|t | ��}|�|� qTW d� |�S )ax Collapse a collection of cell co-ordinates down into an optimal range or collection of ranges. E.g. Cells A1, A2, A3, B1, B2 and B3 should have the data-validation object applied, attempt to collapse down to a single range, A1:B3. Currently only collapsing contiguous vertical ranges (i.e. above example results in A1:A3 B1:B3). c s s | ]}t |�V qd S )N)r )�.0�cellr r �W/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/worksheet/datavalidation.py� <genexpr>( s z*collapse_cell_addresses.<locals>.<genexpr>� )�keyz {0}{1}:{2}{3}z{0}{1}� ) �listr �sortedr �append�itemsr �len�format�min�max�join) �cellsZ input_ranges�rangesZ raw_coordsZgrouped_coords�row�col�fmt�rr r r �collapse_cell_addresses s r( c C s, dd� | � � D �}dd� |D �}tt|� �S )z� Expand cell ranges to a sequence of addresses. Reverse of collapse_cell_addresses Eg. converts "A1:A2 B1:B2" to (A1, A2, B1, B2) c s s | ]}t |�V qd S )N)r )r �rsr r r r B s z%expand_cell_ranges.<locals>.<genexpr>c s s | ]}t |� V qd S )N)r )r r$ r r r r C s )�split�setr )Z range_string�rowsr" r r r �expand_cell_ranges; s r- r )�MultiCellRangec @ s� e Zd ZdZeed�Zed�Zed�Z e dd�Z ed�Z e dd�Z e dd�Ze dd�Zed�Zedd�Zedd�Zedd�Zedd�Zeded�Zeded�Zed d �Zed d �Z ed d �Z ed d �Z ed�Z ddd�Z dd� Z!dd� Z"dS )�DataValidation�dataValidation)� expected_type�sqrefT)� allow_none� showDropDown� allowBlank)r3 r1 )Zwhole�decimalr �date�time� textLengthZcustom)�values)�stop�warning� information) Z noControl�off�on�disabledZhiraganaZ fullKatakanaZ halfKatakanaZ fullAlphaZ halfAlphaZ fullHangulZ halfHangul)ZbetweenZ notBetween�equalZnotEqualZlessThanZlessThanOrEqualZ greaterThanZgreaterThanOrEqual�typeNFr c C sj || _ || _|| _|| _|| _|| _|d k r0|}|| _|| _|| _|| _ | | _ | | _ | | _ | | _ | | _d S )N)r2 r4 �imeMode�operator�formula1�formula2r5 �showErrorMessage�showInputMessagerB � promptTitle� errorStyle�error�prompt� errorTitle)�selfrB rE rF rG rH r4 r5 r2 rI rJ rK rL rM rC rD � allow_blankr r r �__init__j s" zDataValidation.__init__c C s" t |d�r|j}| j|7 _dS )z0Adds a cell or cell coordinate to this validator� coordinateN)�hasattrrQ r2 )rN r r r r �add� s zDataValidation.addc C s t |d�r|j}|| jkS )NrQ )rR rQ r2 )rN r r r r � __contains__� s zDataValidation.__contains__)NNNFFFFr NNNNNNNN)#�__name__� __module__� __qualname__�tagnamer r. r2 r r" r# r r4 Zhide_drop_downrH rG r5 rO r rM rK rI rL r �strrE rF r rB rJ rC rD Zvalidation_typerP rS rT r r r r r/ J sN r/ c sx e Zd ZdZedd�Zedd�Zedd�Ze e d�Z dZ dZ dd d �Zed d � �Zd d� Zdd� Zd� fdd� Z� ZS )�DataValidationListZdataValidationsT)r3 )r1 )r0 )�disablePrompts�xWindow�yWindow�countNr c C s || _ || _|| _|| _d S )N)r[ r\ r] r0 )rN r[ r\ r] r^ r0 r r r rP � s zDataValidationList.__init__c C s t | �S )N)r )rN r r r r^ � s zDataValidationList.countc C s t | j�S )N)r r0 )rN r r r �__len__� s zDataValidationList.__len__c C s | j �|� d S )N)r0 r )rN Zdvr r r r � s zDataValidationList.appendc s2 | j }dd� | j D �| _ tt| ��|�}|| _ |S )zC Need to skip validations that have no cell ranges c S s g | ]}t |j�r|�qS r )�boolr2 )r r' r r r � <listcomp>� s z.DataValidationList.to_tree.<locals>.<listcomp>)r0 �superrZ �to_tree)rN rX r# �xml)� __class__r r rc � s zDataValidationList.to_tree)NNNNr )N)rU rV rW rX r r[ r r\ r] r r/ r0 Z __elements__� __attrs__rP �propertyr^ r_ r rc � __classcell__r r )re r rZ � s rZ N)r ) � collectionsr � itertoolsr rD r Z!openpyxl.descriptors.serialisabler Zopenpyxl.descriptorsr r r r r r r Zopenpyxl.descriptors.nestedr Zopenpyxl.utilsr r r r( r- Z cell_ranger. r/ rZ r r r r �<module> s $ ! R
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка