Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/worksheet/__pycache__/_read_only.cpython-37.pyc
Назад
B �5�gU � @ s` d Z ddlmZ ddlmZmZ ddlmZ ddlm Z ddl m Z dd � Z G d d � d e �Zd S ) z Read worksheets on-demand � )� Worksheet� )� ReadOnlyCell� EMPTY_CELL)�get_column_letter)�WorkSheetParser)�DefinedNameDictc C s t | g �}|�� S )N)r �parse_dimensions)�source�parser� r �S/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/worksheet/_read_only.py�read_dimension s r c @ s� e Zd ZdZdZd ZZejZej Z ej Z ej Z ej Z ej Z dd� Zdd� Zdd� Zd d d �Zd d d �Zdd� Zd dd�Zdd� Zdd� Zedd� �Zedd� �Zedd� �Zed d � �ZdS )!�ReadOnlyWorksheetr Nc C s8 || _ || _d| _d | _|| _|| _| �� t� | _d S )N�visible) �parent�titleZ sheet_stateZ _current_row�_worksheet_path�_shared_strings� _get_sizer Z defined_names)�selfZparent_workbookr Zworksheet_pathZshared_stringsr r r �__init__# s zReadOnlyWorksheet.__init__c C sB | � � }t|g �}|�� }|�� |d k r>|\| _| _| _| _d S )N)� _get_sourcer r �close� _min_column�_min_row� _max_column�_max_row)r �srcr � dimensionsr r r r . s zReadOnlyWorksheet._get_sizec C s | j j�| j�S )z0Parse xml source on demand, must close after use)r Z_archive�openr )r r r r r 7 s z ReadOnlyWorksheet._get_sourceFc c s( t }|r d}|p| j}|p | j}g }|dk r>|f|d | }|}d} | �� ��} t| | j| jj| jj| jj | jj d�} xn| � � D ]b\} } |dk r�| |kr�P x t || �D ]} |d7 }|V q�W || kr�| � | |||�} |d7 }| V q�W W dQ R X |dk �r$|| k �r$x t ||d �D ] } |V �qW dS )zt The source worksheet file may have columns or rows missing. Missing cells will be created. Nr )� data_only�epochZ date_formatsZtimedelta_formats)r � max_column�max_rowr r r r r! r" Z _date_formatsZ_timedelta_formats�parse�range�_get_row)r �min_col�min_row�max_colr$ � values_onlyZfillerZ empty_row�counter�idxr r �row�_r r r � _cells_by_row< s< z ReadOnlyWorksheet._cells_by_rowc C s� |s |s dS |p|d d }|d | }t g| }|r@dg| }xT|D ]L}|d }|| krf|krFn qF|| } |d || < |sFt| f|�|| < qFW t|�S )zT Make sure a row contains always the same number of cells or values r ����columnr N�value)r r �tuple) r r. r( r* r+ Z row_widthZnew_row�cellr, r- r r r r' i s zReadOnlyWorksheet._get_rowc C s* x$| � ||||�D ]}|r|d S qW tS )z4Cells are returned by a generator which can be emptyr )r0 r )r r. r2 r r r � _get_cell� s zReadOnlyWorksheet._get_cellc C sL t | j| jg�s&|r | �� ntd��t| j�� | j� dt| j�� | j� �S )Nz9Worksheet is unsized, use calculate_dimension(force=True)�:)�allr# r$ �_calculate_dimension� ValueErrorr � min_columnr) )r �forcer r r �calculate_dimension� s z%ReadOnlyWorksheet.calculate_dimensionc C s@ d}x(| j D ] }|sq |d }t||j�}q W |j| _|| _dS )z� Loop through all the cells to get the size of a worksheet. Do this only if it is explicitly requested. r r1 N)�rows�maxr2 r. r r )r r* �rr5 r r r r9 � s z&ReadOnlyWorksheet._calculate_dimensionc C s d | _ | _dS )z� Remove worksheet dimensions if these are incorrect in the worksheet source. NB. This probably indicates a bug in the library or application that created the workbook. N)r r )r r r r �reset_dimensions� s z"ReadOnlyWorksheet.reset_dimensionsc C s | j S )N)r )r r r r r) � s zReadOnlyWorksheet.min_rowc C s | j S )N)r )r r r r r$ � s zReadOnlyWorksheet.max_rowc C s | j S )N)r )r r r r r; � s z ReadOnlyWorksheet.min_columnc C s | j S )N)r )r r r r r# � s z ReadOnlyWorksheet.max_column)F)r NF)F) �__name__� __module__� __qualname__r r r r r r5 Z iter_rows�valuesr> � __getitem__�__iter__r r r r0 r' r6 r= r9 rA �propertyr) r$ r; r# r r r r r s, - r N)�__doc__Z worksheetr Zopenpyxl.cell.read_onlyr r Zopenpyxl.utilsr �_readerr Z openpyxl.workbook.defined_namer r �objectr r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.03 |
proxy
|
phpinfo
|
Настройка