Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/worksheet/__pycache__/_reader.cpython-37.pyc
Назад
B �5�g@ � @ s� d Z ddlmZ ddlmZ ddlmZ ddlmZmZ ddl m Z ddl m Z m Z mZ ddlmZmZ dd lmZ dd lmZ dd lmZmZ dd lmZmZm Z dd l m Z ddl m Z ddl!m"Z"m#Z# ddl$m%Z% ddl&m'Z' ddl(m)Z) ddl*m+Z+ ddl,m-Z-m.Z.m/Z/ ddl0m1Z1m2Z2 ddl3m4Z4 ddl5m6Z6 ddl7m8Z8 ddl9m:Z: ddl;m<Z< dd l=m>Z> dd l?m@Z@ dd lAmBZB d e ZCd e ZDd!e ZEd"e ZFd#e ZGd$e ZHd%e ZId&e ZJd'e ZKd(e ZLd)e ZMd*e ZNd+e ZOd,e ZPd-e ZQd.e ZRd/e ZSd0e ZTd1e ZUd2e ZVd3e ZWd4e ZXd5e ZYd6e ZZd7e Z[d8e Z\d9e Z]d:e Z^d;d<� Z_d=d>� Z`G d?d@� d@ea�ZbG dAdB� dBea�ZcdCS )Dz Reader for a single worksheet.� )�copy)�warn)� iterparse)�Cell� MergedCell)�Text)�ColumnDimension� RowDimension�SheetFormatProperties)� SHEET_MAIN_NS� EXT_TYPES)�ConditionalFormatting)� Translator)�get_column_letter�coordinate_to_tuple)� from_excel� from_ISO8601� WINDOWS_EPOCH)� ExtensionList)� CellRichText� )�DataTableFormula� ArrayFormula)� AutoFilter)� HeaderFooter)� HyperlinkList)� MergeCells)� PageMargins� PrintOptions�PrintPageSetup)�RowBreak�ColBreak)�SheetProtection)� ScenarioList)� SheetViewList)�DataValidationList)� TablePartList)�WorksheetProperties)�SheetDimension)�Relatedz{%s}cz{%s}vz{%s}fz{%s}mergeCellsz{%s}isz{%s}colz{%s}rowz{%s}conditionalFormattingz{%s}legacyDrawingz{%s}sheetProtectionz {%s}extLstz{%s}hyperlinksz{%s}tablePartsz{%s}printOptionsz{%s}pageMarginsz {%s}pageSetupz{%s}headerFooterz{%s}autoFilterz{%s}dataValidationsz {%s}sheetPrz{%s}sheetViewsz{%s}sheetFormatPrz {%s}rowBreaksz {%s}colBreaksz {%s}scenariosz {%s}sheetDataz {%s}dimensionz{%s}customSheetViewsc C s( d| ksd| ksd| kr t | �S t| �S )z,Convert numbers as string to an int or float�.�E�e)�float�int)�value� r0 �P/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/worksheet/_reader.py� _cast_numberP s r2 c C s4 t �| �p d}t|�dkr0t|d t�r0|d }|S )z? Parse inline string and preserve rich text formatting � r r )r � from_tree�len� isinstance�str)�elementr/ r0 r0 r1 �parse_richtext_stringW s r9 c @ s� e Zd Zdee� e� dfdd�Zdd� Zdd� Zdd � Zd d � Z d d � Z dd� Z dd� Z dd� Z dd� Zdd� Zdd� Zdd� Zd d � Zd S ) �WorkSheetParserFc C s� d | _ | _|| _|| _|| _|| _i | _d | _| _t � | _ || _ || _ i | _ i | _g | _d| _t� | _g | _d | _d | _t� | _t� | _|| _d S )Nr F)Zmin_rowZmin_col�epoch�source�shared_strings� data_only�shared_formulae� row_counter� col_counterr& �tables� date_formats�timedelta_formats�row_dimensions�column_dimensionsZnumber_formatsZkeep_vbar � hyperlinks� formatting�legacy_drawing� merged_cellsr � row_breaksr! � col_breaks� rich_text)�self�srcr= r> r; rC rD rM r0 r0 r1 �__init__c s* zWorkSheetParser.__init__c c s> t | jt| jt| jt| jt| j t | j t | j t| ji}tdtftdtftdtftdtftdtftdtft dt ft dt ft d t!ft"d t#ft$d t%ft&d t'ft(d t)fi }t*| j+�}x�|D ]�\}}|j,}||kr�|| |� |�-� q�||k�r|| }|d �.|�}t/| |d |� |�-� q�|t0kr�| �1|�} |�-� | V q�W d S )N� print_options� page_margins� page_setupr � auto_filter�data_validations�sheet_properties�views� sheet_format� scenariosrB rG rJ r r )2�COL_TAG�parse_column_dimensions�PROT_TAG�parse_sheet_protection�EXT_TAG�parse_extensions�CF_TAG�parse_formatting� LEGACY_TAG� parse_legacy� ROW_BREAK_TAG�parse_row_breaks� COL_BREAK_TAG�parse_col_breaks�CUSTOM_VIEWS_TAG�parse_custom_views� PRINT_TAGr � MARGINS_TAGr �PAGE_TAGr � HEADER_TAGr � FILTER_TAGr �VALIDATION_TAGr% �PROPERTIES_TAGr' � VIEWS_TAGr$ � FORMAT_TAGr � SCENARIOS_TAGr# � TABLE_TAGr& � HYPERLINK_TAGr � MERGE_TAGr r r< �tag�clearr4 �setattr�ROW_TAG� parse_row) rN Z dispatcher� properties�it�_r8 Ztag_name�prop�obj�rowr0 r0 r1 �parse} sH zWorkSheetParser.parsec C sN t | j�}x>|D ]6\}}|jtkr2t�|�}|jS |jtkr>P |�� qW dS )z@ Get worksheet dimensions if they are provided. N) r r< rw � DIMENSION_TAGr( r4 Z boundaries�DATA_TAGrx )rN r} Z_eventr8 �dimr0 r0 r1 �parse_dimensions� s z WorkSheetParser.parse_dimensionsc C s� |� dd�}|� d�}|� dd�}|r.t|�}|dkr<d }n|�td �pJd }|rdt|�\}}|| _n | jd7 _| j| j }}| js�|�t �d k r�d}| � |�}�n |d k �r�|dk�r,t |�}|| j k�r�d }yt || j|| jkd �}W n< ttfk �r( d |� d |� d �}t|� d}d}Y nX nT|dk�rF| jt|� }n:|dk�r^tt|��}n"|dk�rnd}n|d k�r�t|�}n@|dk�r�|�t�} | d k �r�d}| j�r�t| �}n t�| �j}|||||d�S )N�t�n�r�sr Z inlineStrr �f�d)� timedeltazCell z* is marked as a date but the serial value zG is outside the limits for dates. The cell will be treated as an error.r, z#VALUE!�br7 )r� �columnr/ � data_type�style_id) �getr. Zfindtext� VALUE_TAGr rA r@ r> �find� FORMULA_TAG� parse_formular2 rC r r; rD � OverflowError� ValueErrorr r= �boolr � INLINE_STRINGrM r9 r r4 �content) rN r8 r� � coordinater� r/ r� r� �msg�childr0 r0 r1 � parse_cell� sZ zWorkSheetParser.parse_cellc C s� |� t�}|�d�}|�d�}d}|jdk r6||j7 }|dkrRt|�d�|d�}n`|dkr�|�d �}|| jkr�| j| }|�|�}q�|dkr�t||�| j|< n|d kr�tf |j �}|S ) zC possible formulae types: shared, array, datatable r� r� �=N�array�ref)r� �textZshared�siZ dataTable) r� r� r� r� r r? Ztranslate_formular r �attrib)rN r8 �formulaZ formula_typer� r/ �idxZtransr0 r0 r1 r� � s$ z WorkSheetParser.parse_formulac C s0 t |j�}tt|d ��}||d< || j|< d S )N�min�index)�dictr� r r. rF )rN �col�attrsr� r0 r0 r1 r[ s z'WorkSheetParser.parse_column_dimensionsc s� t |j�}d|krnyt|d �� _W q| tk rj t|d �}|�� rTt|�� _nt|d � d���Y q|X n� jd7 _d� _dd� |D �}|ddh r�|� jt � j�< � fdd �|D �}� j|fS ) Nr� z is not a valid row numberr r c S s h | ]}|� d �s|�qS )�{)� startswith)�.0�kr0 r0 r1 � <setcomp>* s z,WorkSheetParser.parse_row.<locals>.<setcomp>�spansc s g | ]}� � |��qS r0 )r� )r� �el)rN r0 r1 � <listcomp>/ s z-WorkSheetParser.parse_row.<locals>.<listcomp>) r� r� r. r@ r� r- � is_integerrA rE r7 )rN r� r� �val�keys�cellsr0 )rN r1 r{ s zWorkSheetParser.parse_rowc C sT yt �|�}| j�|� W n4 tk rN } zd|� �}t|� W d d }~X Y nX d S )NzKFailed to load a conditional formatting rule. It will be discarded. Cause: )r r4 rH �append� TypeErrorr )rN r8 �cfr, r� r0 r0 r1 ra 3 s z WorkSheetParser.parse_formattingc C s2 t �|�}|�d�}|d k r(|�|d� || _d S )N�passwordT)r" r4 r� � set_password� protection)rN r8 r� r� r0 r0 r1 r] < s z&WorkSheetParser.parse_sheet_protectionc C sB t �|�}x2|jD ](}t�|j�� d�}d�|�}t|� qW d S )N�Unknownz2{0} extension is not supported and will be removed) r r4 �extr r� �uri�upper�formatr )rN r8 ZextLstr, Zext_typer� r0 r0 r1 r_ D s z WorkSheetParser.parse_extensionsc C s t �|�}|j| _d S )N)r) r4 �idrI )rN r8 r� r0 r0 r1 rc L s z WorkSheetParser.parse_legacyc C s t �|�}|| _d S )N)r r4 rK )rN r8 �brkr0 r0 r1 re Q s z WorkSheetParser.parse_row_breaksc C s t �|�}|| _d S )N)r! r4 rL )rN r8 r� r0 r0 r1 rg V s z WorkSheetParser.parse_col_breaksc C s t � | _t� | _d S )N)r rK r! rL )rN r8 r0 r0 r1 ri [ s z"WorkSheetParser.parse_custom_viewsN)�__name__� __module__� __qualname__r �setrP r� r� r� r� r[ r{ ra r] r_ rc re rg ri r0 r0 r0 r1 r: a s /: r: c @ sh e Zd ZdZdd� Zdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z dd� Z dd� Z dd� Z dd� ZdS )�WorksheetReaderz4 Create a parser and apply it to a workbook c C s2 || _ t||||jj|jj|jj|�| _g | _d S )N)�wsr: �parentr; Z _date_formatsZ_timedelta_formats�parserrB )rN r� Z xml_sourcer= r> rM r0 r0 r1 rP g s zWorksheetReader.__init__c C s� x|| j �� D ]n\}}xd|D ]\}| jjj|d }t| j|d |d |d�}|d |_|d |_|| jj|d |d f< qW q W | jjr�| jj | j_ d S )Nr� r� r� )r� r� Z style_arrayr/ r� ) r� r� r� r� � _cell_stylesr �_valuer� �_cellsZmax_rowZ _current_row)rN r� r� �cell�style�cr0 r0 r1 � bind_cellso s zWorksheetReader.bind_cellsc C sN xH| j jD ]<}x6|jD ],}|jd k r6| jjj|j |_|| jj|< qW q W d S )N) r� rH �rulesZdxfIdr� r� Z_differential_stylesZdxfZconditional_formatting)rN r� �ruler0 r0 r1 �bind_formatting| s z WorksheetReader.bind_formattingc C s6 x0| j jjD ]"}| jj�|j�}| j�|j� q W d S )N) r� rB Z tablePartr� �_relsr� r� r� �Target)rN r� �relr0 r0 r1 � bind_tables� s zWorksheetReader.bind_tablesc C sp ddl m} ddlm} | jjs$d S g }x6| jjjD ](}|| j|j�}| j� |� |� |� q4W ||�| j_d S )Nr )�MultiCellRange)�MergedCellRange) Z openpyxl.worksheet.cell_ranger� Zopenpyxl.worksheet.merger� r� rJ Z mergeCellr� r� Z_clean_merge_ranger� )rN r� r� �ranges�crZmcrr0 r0 r1 �bind_merged_cells� s z!WorksheetReader.bind_merged_cellsc C s� x�| j jjD ]�}|jr.| jj�|j�}|j|_d|j kr�xp| j|j D ]6}x0|D ](}yt |�|_W qP t k rv Y qPX qPW qFW q | j|j }t |t �r�| �|j�}||_q W d S )N�:)r� rG � hyperlinkr� r� r� r� r� �targetr� r �AttributeErrorr6 r �normalize_merged_cell_linkr� )rN �linkr� r� r� r0 r0 r1 �bind_hyperlinks� s z WorksheetReader.bind_hyperlinksc C s0 x*| j jD ] }||kr | j j|jd � S q W dS )z� Returns the appropriate cell to which a hyperlink, which references a merged cell at the specified coordinates, should be bound. r N)r� rJ r� �top)rN Zcoord�rngr0 r0 r1 r� � s z*WorksheetReader.normalize_merged_cell_linkc C sZ xT| j j�� D ]D\}}d|kr<t|d �}| jjj| |d< t| jf|�| jj|< qW d S )Nr� )r� rF �itemsr. r� r� r� r )rN r� �cd�keyr0 r0 r1 �bind_col_dimensions� s z#WorksheetReader.bind_col_dimensionsc C s^ xX| j j�� D ]H\}}d|kr<t|d �}| jjj| |d< t| jf|�| jjt|�< qW d S )Nr� )r� rE r� r. r� r� r� r )rN r� �rdr� r0 r0 r1 �bind_row_dimensions� s z#WorksheetReader.bind_row_dimensionsc C s6 x0dD ](}t | j|d �}|d k rt| j||� qW d S )N)rQ rR rS r rT rU rV rW rX rK rL rY rI r� )�getattrr� ry r� )rN r� �vr0 r0 r1 �bind_properties� s z WorksheetReader.bind_propertiesc C sD | � � | �� | �� | �� | �� | �� | �� | �� d S )N)r� r� r� r� r� r� r� r� )rN r0 r0 r1 �bind_all� s zWorksheetReader.bind_allN)r� r� r� �__doc__rP r� r� r� r� r� r� r� r� r� r� r0 r0 r0 r1 r� b s r� N)dr� r �warningsr Zopenpyxl.xml.functionsr Z openpyxl.cellr r Zopenpyxl.cell.textr Z openpyxl.worksheet.dimensionsr r r Zopenpyxl.xml.constantsr r Z openpyxl.formatting.formattingr Zopenpyxl.formula.translater Zopenpyxl.utilsr r Zopenpyxl.utils.datetimer r r Zopenpyxl.descriptors.excelr Zopenpyxl.cell.rich_textr r� r r �filtersr Z header_footerr r� r �merger �pager r r Z pagebreakr r! r� r" Zscenarior# rW r$ Zdatavalidationr% �tabler& r| r' � dimensionsr( �relatedr) ZCELL_TAGr� r� rv r� rZ rz r` rb r\ r^ ru rt rj rk rl rm rn ro rp rq rr rd rf rs r� r� rh r2 r9 �objectr: r� r0 r0 r0 r1 �<module> s|
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка