Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/openpyxl/reader/__pycache__/excel.cpython-37.pyc
Назад
B �5�gE0 � @ s� d Z ddlmZmZ ddlmZ ddlZddlZddl m Z yddl m Z W n e k rd dZ Y nX dd lmZ dd lmZmZmZmZmZmZmZmZmZmZmZ dd l m Z dd l m Z d dl m!Z!m"Z" d dl#m$Z$ ddl%m&Z& ddl'm(Z( ddl)m*Z* ddl+m,Z,m-Z- ddl.m/Z/m0Z0m1Z1 ddl2m3Z3 ddl4m5Z5 ddl6m7Z7 ddl8m9Z9 ddl:m;Z; ddl<m=Z= d dl>m?Z? d Z@d d � ZAd d � ZBG d!d"� d"�ZCde dd#dfd$d%�ZDdS )&z Read an xlsx file into Python� )�ZipFile� ZIP_DEFLATED)�BytesION)�TableDefinition� )�KEEP_VBAF)�InvalidFileException) �ARC_CORE� ARC_CUSTOM�ARC_CONTENT_TYPES� ARC_WORKBOOK� ARC_THEME� COMMENTS_NS�SHARED_STRINGS�XLTM�XLTX�XLSM�XLSX)� MergedCell)� CommentSheet� )�read_string_table�read_rich_text)�WorkbookParser)�apply_stylesheet)�DocumentProperties)�CustomPropertyList)�Manifest�Override)�RelationshipList�get_dependents� get_rels_path)�ReadOnlyWorksheet)�WorksheetReader)� Chartsheet)�Table)�SpreadsheetDrawing)� fromstring)� find_images)z.xlsxz.xlsmz.xltxz.xltmc C sn t | d�}|s`tj�| �d �� }|tkr`|dkr8d}n |dkrFd}nd|d�t�f }t|��t| d �}|S ) a� Does a first check whether filename is a string or a file-like object. If it is a string representing a filename, a check is done for supported formats by checking the given file-extension. If the file-extension is not in SUPPORTED_FORMATS an InvalidFileException will raised. Otherwise the filename (resp. file-like object) will forwarded to zipfile.ZipFile returning a ZipFile-Instance. �read���z.xlsz�openpyxl does not support the old .xls file format, please use xlrd to read this file, or convert it to the more recent .xlsx file format.z.xlsbz|openpyxl does not support binary format .xlsb, please convert this file to .xlsx format if you want to open it with openpyxlzropenpyxl does not support %s file format, please check you can open it with Excel first. Supported formats are: %s�,�r) �hasattr�os�path�splitext�lower�SUPPORTED_FORMATS�joinr r )�filenameZ is_file_likeZ file_format�msg�archive� r7 �K/home/digitalm-up/venv/lib/python3.7/site-packages/openpyxl/reader/excel.py�_validate_archiveB s r9 c C sj t tttg}x |D ]}| �|�}|r|S qW dd� | jD �}|t|�@ }|r^tdt |� � �S t d��d S )Nc S s h | ] }|j �qS r7 )� ContentType)�.0�pr7 r7 r8 � <setcomp>k s z&_find_workbook_part.<locals>.<setcomp>�/z$File contains no valid workbook part) r r r r �findZDefault�setr r �pop�IOError)�packageZworkbook_types�ct�part�defaultsZ workbook_typer7 r7 r8 �_find_workbook_partc s rG c @ sl e Zd ZdZdedddfdd�Zdd� Zdd � Zd d � Zd d � Z dd� Z dd� Z dd� Z dd� Z dd� ZdS )� ExcelReaderzQ Read an Excel package and dispatch the contents to the relevant modules FTc C s> t |�| _| j�� | _|| _|| _|| _|| _|| _g | _ d S )N) r9 r6 �namelist� valid_files� read_only�keep_vba� data_only� keep_links� rich_text�shared_strings)�self�fnrK rL rM rN rO r7 r7 r8 �__init__y s zExcelReader.__init__c C s$ | j �t�}t|�}t�|�| _d S )N)r6 r) r r' r � from_treerC )rQ �src�rootr7 r7 r8 � read_manifest� s zExcelReader.read_manifestc C sV | j �t�}t}| jrt}|d k rR|jdd � }| j�|��}||�| _ W d Q R X d S )Nr ) rC r? r r rO r �PartNamer6 �openrP )rQ rD �readerZ strings_pathrU r7 r7 r8 � read_strings� s zExcelReader.read_stringsc C s� t | j�}t| j|jdd � | jd�| _| j�� | jj}g |_ | j |_ | j |_ |jttfk|_| jr�tt� dt�|_x$| jD ]}|j�|| j�|�� q~W | j r�| j|_|| _d S )Nr )rN �a)rG rC r r6 rX rN �parser�parse�wb�_sheetsrM Z _data_onlyrK Z _read_onlyr: r r �templaterL r r r � vba_archiverJ �writestrr) Z_archive)rQ Zwb_partr_ �namer7 r7 r8 � read_workbook� s zExcelReader.read_workbookc C s, t | jkr(t| j�t ��}t�|�| j_d S )N) r rJ r' r6 r) r rT r_ � properties)rQ rU r7 r7 r8 �read_properties� s zExcelReader.read_propertiesc C s, t | jkr(t| j�t ��}t�|�| j_d S )N) r rJ r' r6 r) r rT r_ Zcustom_doc_props)rQ rU r7 r7 r8 � read_custom� s zExcelReader.read_customc C s t | jkr| j�t �| j_d S )N)r rJ r6 r) r_ Z loaded_theme)rQ r7 r7 r8 � read_theme� s zExcelReader.read_themec C s� |j }t|�}g }|| jkr(t| j|�}| j�|d��}|�� }W d Q R X t|�}t� |�} | j | _ |j | _ | j �| � |�tj�} x6| D ].}t| j|j �\} } x| D ]} | �| � q�W q�W d S )Nr, )�targetr! rJ r r6 rY r) r' r$ rT r_ �_parentrd �titleZ _add_sheetr? r& � _rel_typer( � add_chart)rQ �sheet�relZ sheet_path� rels_path�relsrU �xml�node�cs�drawings�charts�images�cr7 r7 r8 �read_chartsheet� s" zExcelReader.read_chartsheetc C s� d}�x�| j �� D �]�\}}|j| jkr*qd|jkrB| �||� qt|j�}t� }|| jkrht| j |�}| j r�t | j |j |j| j�}|j|_| j j�|� qnH| j �|j�}| j �|j �}||_t||| j| j| j�}|�� |�� x�|�t �D ]�} | j � | j�} t � t | ��} xh| j!D ]^\} } y| || _"W nD t#k �rt || }t$|t%��rpt&�'|�(|j)|j*�� �wY nX �qW q�W | j j+�r�|j,�r�|�-|j,�j|_,nd |_,x8|j.D ].}| j � |�} t | �}t/� |�}|�0|� �q�W |�t1j2�}x\|D ]T}t3| j |j�\}}x |D ]}|�4||j5� �qW x |D ]}|�6||j5� �q0W �q�W |�t7j8�}| j j9}xH|D ]@} | j:}| j � |�} t | �}t7� |�}||j; |_<|�=|� �qhW |j|_qW d S )Nz~Cell '{0}':{1} is part of a merged range but has a comment which will be removed because merged cells cannot contain any data.Z chartsheet)>r] Z find_sheetsrj rJ �Typerz r! r r r6 rK r" r_ rd rP �stateZ sheet_stater` �appendrY Z create_sheetZ_relsr# rM rO Zbind_all�closer? r r) r rT r' �comments�comment�AttributeError� isinstancer �warnings�warn�formatrl Z coordinaterb Zlegacy_drawing�getZtablesr% Z add_tabler& rm r( rn �anchorZ add_imager Zrel_type� pivot_cachesZTargetZcacheId�cacheZ add_pivot)rQ Zcomment_warningro rp rq rr �ws�fhZ ws_parserr, rU Z comment_sheet�refr� ry �trs �tablerv rw rx ZimZ pivot_relr� Z pivot_path�treeZpivotr7 r7 r8 �read_worksheets� st zExcelReader.read_worksheetsc C s� d}y�| � � d}| �� d}| �� d}| �� d}| �� d}| �� d}t| j| j� d}| � � d }| j � � | j s�| j� � W n> tk r� } z td |� d | jj� d ��|�W d d }~X Y nX d S ) Nz read manifestz read stringsz read workbookzread propertieszread custom propertiesz read themezread stylesheetzread worksheetsz assign namesz#Unable to read workbook: could not z from z~. This is most probably because the workbook source files contain some invalid XML. Please see the exception for more details.)rW r[ re rg rh ri r r6 r_ r� r] Z assign_namesrK r~ � ValueErrorr4 )rQ �action�er7 r7 r8 r) s2 zExcelReader.readN)�__name__� __module__� __qualname__�__doc__r rS rW r[ re rg rh ri rz r� r) r7 r7 r7 r8 rH s s JrH Tc C s t | |||||�}|�� |jS )aE Open the given filename and return the workbook :param filename: the path to open or a file-like object :type filename: string or a file-like object open in binary mode c.f., :class:`zipfile.ZipFile` :param read_only: optimised for reading, content cannot be edited :type read_only: bool :param keep_vba: preserve vba content (this does NOT mean you can use it) :type keep_vba: bool :param data_only: controls whether cells with formulae have either the formula (default) or the value stored the last time Excel read the sheet :type data_only: bool :param keep_links: whether links to external workbooks should be preserved. The default is True :type keep_links: bool :param rich_text: if set to True openpyxl will preserve any rich text formatting in cells. The default is False :type rich_text: bool :rtype: :class:`openpyxl.workbook.Workbook` .. note:: When using lazy load, all worksheets will be :class:`openpyxl.worksheet.iter_worksheet.IterableWorksheet` and the returned workbook will be read-only. )rH r) r_ )r4 rK rL rM rN rO rZ r7 r7 r8 � load_workbook< s r� )Er� �zipfiler r �ior �os.pathr. r� Zopenpyxl.pivot.tabler �testsr � ImportErrorZopenpyxl.utils.exceptionsr Zopenpyxl.xml.constantsr r r r r r r r r r r Z openpyxl.cellr Z openpyxl.comments.comment_sheetr �stringsr r Zworkbookr Zopenpyxl.styles.stylesheetr Zopenpyxl.packaging.corer Zopenpyxl.packaging.customr Zopenpyxl.packaging.manifestr r Z openpyxl.packaging.relationshipr r r! Z openpyxl.worksheet._read_onlyr" Zopenpyxl.worksheet._readerr# Zopenpyxl.chartsheetr$ Zopenpyxl.worksheet.tabler% Z$openpyxl.drawing.spreadsheet_drawingr& Zopenpyxl.xml.functionsr' rv r( r2 r9 rG rH r� r7 r7 r7 r8 �<module> sD 4 ! J
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка