Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/utils/__pycache__/cell.cpython-37.pyc
Назад
B �5�g7 � @ s d Z ddlmZ ddlmZmZ ddlmZmZ ddl Z ddl m Z e � d�Z d Zd Zd Ze � d e d e j�ZdZe � d�ee�e j�Zdd� Zdd� Zdd� Zdgee� Zedd�dd� �Zdd� e ed�D �Z d Z edd�d d � �Z d d � Z d!d"� Z!d#d$� Z"d%d&� Z#d'd(� Z$d)d*� Z%dS )+zT Collection of utilities used within the package and also available for client code � )� lru_cache)�chain�product)�ascii_uppercase�digitsN� )�CellCoordinatesExceptionz ^[$]?([A-Za-z]{1,3})[$]?(\d+)$z[A-Z]{1,3}:[A-Z]{1,3}:z\d+:\d+:zq [$]?(?P<min_col>[A-Za-z]{1,3})? [$]?(?P<min_row>\d+)? (:[$]?(?P<max_col>[A-Za-z]{1,3})? [$]?(?P<max_row>\d+)?)? �^�$z7 (('(?P<quoted>([^']|'')*)')|(?P<notquoted>[^'^ ^!]*))!z{0}(?P<cells>{1})(?=,?)c C s< t | t�rt| �} t |t�r$t|�}dd� t| |d �D �S )z� Given the start and end columns, return all the columns in the series. The start and end columns can be either column letters or 1-based indexes. c S s g | ] }t |��qS � )�get_column_letter)�.0�xr r �I/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/utils/cell.py� <listcomp>) s z'get_column_interval.<locals>.<listcomp>r )� isinstance�str�column_index_from_string�range)�start�endr r r �get_column_interval s r c C sV t �| �}|s"d| � d�}t|��|�� \}}t|�}|sNd| � d�}t|��||fS )z;Convert a coordinate string like 'B12' to a tuple ('B', 12)zInvalid cell coordinates (�)zThere is no row 0 ()�COORD_RE�matchr �groups�int)� coord_stringr �msg�column�rowr r r �coordinate_from_string, s r! c C st t �| �}|s t| � d���|�d�}x&|�� D ]\}}|r0d|� �||< q0W |d s^|d rdd}nd}|jf |�S )zDConvert a coordinate to an absolute coordinate string (B12 -> $B$12)z is not a valid coordinate range� r �max_col�max_rowz%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row})� ABSOLUTE_REr � ValueError� groupdict�items�format)r �m�d�k�v�fmtr r r �absolute_coordinate: s r/ r" )�maxsizec C s� d| krdks$n t d�| ���g }| dk r8t| S x>| rvt| d�\} }|�dt| � |s:| d8 } |�dd� q:W d�|�S )a� Convert decimal column position to its ASCII (base 26) form. Because column indices are 1-based, strides are actually pow(26, n) + 26 Hence, a correction is applied between pow(26, n) and pow(26, 2) + 26 to prevent and additional column letter being prepended "A" == 1 == pow(26, 0) "Z" == 26 == pow(26, 0) + 26 // decimal equivalent 10 "AA" == 27 == pow(26, 1) + 1 "ZZ" == 702 == pow(26, 2) + 26 // decimal equivalent 100 r ifG zInvalid column index {0}� r �Zr" )r& r) �__decimal_to_alpha�divmod�insert�join)Zcol_idx�result� remainderr r r r N s r c C s i | ]\}}||�qS r r )r �pos�letterr r r � <dictcomp>o s r; )r r1 i� c C s� d| � d�}t | �dkr t|��d}t| �� �} xLt| t�D ]>\}}y t| }W n tk rl t|��Y nX ||| 7 }q<W d| k r�dk s�n t|��|S )z� Convert ASCII column name (base 26) to decimal with 1-based index Characters represent descending multiples of powers of 26 "AFZ" == 26 * pow(26, 0) + 6 * pow(26, 1) + 1 * pow(26, 2) �'z<' is not a valid column name. Column names are from A to ZZZ� r igG )�lenr& �reversed�upper�zip�__powers�__alpha_to_decimal�KeyError)�col� error_msg�idxr: �powerr9 r r r r r s r c C s� d� | �}t�| �}|s t|��|�� \}}}}}|rz||f}||f} t|| �szt|�rbt| �rzt| �rrt|�rzt|��|dk r�t|�}|dk r�t|�}|dk r�t|�}n|}|dk r�t|�}n|}||||fS )z� Convert a range string into a tuple of boundaries: (min_col, min_row, max_col, max_row) Cell coordinates will be converted into a range with the cell at both end z&{0} is not a valid coordinate or rangeN) r) r% r r& r �all�anyr r ) � range_stringr r* �min_col�min_row�sepr# r$ �cols�rowsr r r �range_boundaries� s. rQ c # s` t | �\}}}}t||d �}dd� t||d �D �}x$|D ] � t� fdd�|D ��V q<W dS )z[ Get individual addresses for every cell in a range. Yields one row at a time. r c S s g | ] }t |��qS r )r )r rE r r r r � s z#rows_from_range.<locals>.<listcomp>c 3 s | ]}d � |� �V qdS )z{0}{1}N)r) )r rE )r r r � <genexpr>� s z"rows_from_range.<locals>.<genexpr>N)rQ r �tuple)rK rL rM r# r$ rP rO r )r r �rows_from_range� s rT c # s` t | �\}}}}t||d �}dd� t||d �D �}x$|D ] � t� fdd�|D ��V q<W dS )z[ Get individual addresses for every cell in a range. Yields one row at a time. r c s s | ]}t |�V qd S )N)r )r rE r r r rR � s z"cols_from_range.<locals>.<genexpr>c 3 s | ]}d � � |�V qdS )z{0}{1}N)r) )r r )rE r r rR � s N)rQ r rS )rK rL rM r# r$ rP rO r )rE r �cols_from_range� s rU c C sH x t | �D ]\}}|tkr P q W | d|� }| |d� }t|�t|�fS )zB Convert an Excel style coordinate to (row, column) tuple N)� enumerater r r )Z coordinaterG �crE r r r r �coordinate_to_tuple� s rX c C sH t �| �}|dkrtd��|�d�p,|�d�}|�d�}t|�}||fS )zc Convert a worksheet range to the sheetname and maximum and minimum coordinate indices Nz)Value must be of the form sheetname!A1:E4�quotedZ notquoted�cells)� SHEETRANGE_REr r& �grouprQ )rK r* � sheetnamerZ Z boundariesr r r �range_to_tuple� s r^ c C s" d| kr| � dd�} d�| �} | S )z> Add quotes around sheetnames if they contain spaces. r< z''z'{0}')�replacer) )r] r r r �quote_sheetname� s r` )&�__doc__� functoolsr � itertoolsr r �stringr r �re� exceptionsr �compiler Z COL_RANGEZ ROW_RANGEZ RANGE_EXPR�VERBOSEr% Z SHEET_TITLEr) r[ r r! r/ �listr3 r rV rC rB r rQ rT rU rX r^ r` r r r r �<module> s6 !+
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.03 |
proxy
|
phpinfo
|
Настройка