a C gE0@sdZddlmZmZddlmZddlZddlZddl m Z zddl m Z Wne ybdZ Yn0dd lmZdd lmZmZmZmZmZmZmZmZmZmZmZdd lmZdd lmZd 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/m0Z0m1Z1ddl2m3Z3ddl4m5Z5ddl6m7Z7ddl8m9Z9ddl:m;Z;ddlm?Z?dZ@ddZAdd ZBGd!d"d"ZCde dd#dfd$d%ZDdS)&zRead an xlsx file into Python)ZipFile ZIP_DEFLATED)BytesION)TableDefinition)KEEP_VBAF)InvalidFileException) ARC_CORE ARC_CUSTOMARC_CONTENT_TYPES ARC_WORKBOOK ARC_THEME COMMENTS_NSSHARED_STRINGSXLTMXLTXXLSMXLSX) MergedCell) CommentSheet)read_string_tableread_rich_text)WorkbookParser)apply_stylesheet)DocumentProperties)CustomPropertyList)ManifestOverride)RelationshipListget_dependents get_rels_path)ReadOnlyWorksheet)WorksheetReader) Chartsheet)Table)SpreadsheetDrawing) fromstring) find_images)z.xlsxz.xlsmz.xltxz.xltmcCsnt|d}|s`tj|d}|tvr`|dkr8d}n |dkrFd}nd|dtf}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. readz.xlszopenpyxl 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) hasattrospathsplitextlowerSUPPORTED_FORMATSjoinrr)filenameZ is_file_likeZ file_formatmsgarchiver7T/var/www/lab.imftr.de/x/nb_venv/lib/python3.9/site-packages/openpyxl/reader/excel.py_validate_archiveBs  r9cCsjttttg}|D]}||}|r|Sqdd|jD}|t|@}|r^tdt| St ddS)NcSsh|] }|jqSr7) ContentType).0pr7r7r8 kz&_find_workbook_part../z$File contains no valid workbook part) rrrrfindZDefaultsetrr popIOError)packageZworkbook_typesctpartdefaultsZ workbook_typer7r7r8_find_workbook_partcs    rHc@sleZdZdZdedddfddZddZdd Zd d Zd d Z ddZ ddZ ddZ ddZ ddZdS) ExcelReaderzQ Read an Excel package and dispatch the contents to the relevant modules FTcCs>t||_|j|_||_||_||_||_||_g|_ dSN) r9r6namelist valid_files read_onlykeep_vba data_only keep_links rich_textshared_strings)selffnrMrNrOrPrQr7r7r8__init__ys  zExcelReader.__init__cCs$|jt}t|}t||_dSrJ)r6r)r r'r from_treerD)rSsrcrootr7r7r8 read_manifests zExcelReader.read_manifestcCsj|jt}t}|jrt}|durf|jdd}|j|}|||_ Wdn1s\0YdS)Nr) rDr@rrrQrPartNamer6openrR)rSrEreaderZ strings_pathrWr7r7r8 read_stringss zExcelReader.read_stringscCst|j}t|j|jdd|jd|_|j|jj}g|_ |j |_ |j |_ |jttfv|_|jrttdt|_|jD]}|j||j|q||j r|j|_||_dS)Nr)rPa)rHrDrr6rZrPparserparsewb_sheetsrOZ _data_onlyrMZ _read_onlyr:rrtemplaterNrrr vba_archiverLwritestrr)Z_archive)rSZwb_partranamer7r7r8 read_workbooks   zExcelReader.read_workbookcCs,t|jvr(t|jt}t||j_dSrJ) r rLr'r6r)rrVraZ propertiesrSrWr7r7r8read_propertiess zExcelReader.read_propertiescCs,t|jvr(t|jt}t||j_dSrJ) r rLr'r6r)rrVraZcustom_doc_propsrhr7r7r8 read_customs zExcelReader.read_customcCst|jvr|jt|j_dSrJ)r rLr6r)raZ loaded_theme)rSr7r7r8 read_themes zExcelReader.read_themecCs|j}t|}g}||jvr(t|j|}|j|d}|}Wdn1sT0Yt|}t |} |j | _ |j | _ |j | |tj} | D]*}t|j|j\} } | D]} | | qqdS)Nr,)targetr!rLr r6r[r)r'r$rVra_parentrftitleZ _add_sheetr@r& _rel_typer( add_chart)rSsheetrelZ sheet_path rels_pathrelsrWxmlnodecsdrawingschartsimagescr7r7r8read_chartsheets"  &   zExcelReader.read_chartsheetc Csd}|jD]\}}|j|jvr&qd|jvr>|||qt|j}t}||jvrdt|j |}|j rt |j |j |j|j}|j|_|j j|qnH|j |j}|j |j }||_t|||j|j|j}|||tD]} |j | j} tt | } | j!D]^\} } z| || _"WnDt#yl|| }t$|t%rht&'|(|j)|j*YqYn0qq|j j+r|j,r|-|j,j|_,nd|_,|j.D].}|j |} t | }t/|}|0|q|t1j2}|D]L}t3|j |j\}}|D]}|4||j5q|D]}|6||j5qq|t7j8}|jj9}|D]@} | j:}|j |} t | }t7|}||j;|_<|=|qJ|j|_qdS)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_sheetsrlrLTyper|r!rr r6rMr"rarfrRstateZ sheet_staterbappendr[Z create_sheetZ_relsr#rOrQZbind_allcloser@rr)rrVr'commentscommentAttributeError isinstancerwarningswarnformatrnZ coordinaterdZlegacy_drawinggetZtablesr%Z add_tabler&ror(rpanchorZ add_imagerZrel_type pivot_cachesZTargetZcacheIdcacheZ add_pivot)rSZcomment_warningrqrrrsrtwsfhZ ws_parserr,rWZ comment_sheetrefrr{trutablerxryrzZimZ pivot_relrZ pivot_pathtreeZpivotr7r7r8read_worksheetsst               zExcelReader.read_worksheetsc Csd}z|d}|d}|d}|d}|d}|d}t|j|jd}| d }|j |j s|j Wn@ty}z(td |d |jjd |WYd}~n d}~00dS) 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.)rYr]rgrirjrkrr6rarr_Z assign_namesrMr ValueErrorr4)rSactioner7r7r8r)s6 zExcelReader.readN)__name__ __module__ __qualname____doc__rrUrYr]rgrirjrkr|rr)r7r7r7r8rIss  JrITcCs t||||||}||jS)aEOpen 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. )rIr)ra)r4rMrNrOrPrQr\r7r7r8 load_workbook<s r)Erzipfilerrioros.pathr.rZopenpyxl.pivot.tablertestsr ImportErrorZopenpyxl.utils.exceptionsrZopenpyxl.xml.constantsr r r r r rrrrrrZ openpyxl.cellrZopenpyxl.comments.comment_sheetrstringsrrZworkbookrZopenpyxl.styles.stylesheetrZopenpyxl.packaging.corerZopenpyxl.packaging.customrZopenpyxl.packaging.manifestrrZopenpyxl.packaging.relationshiprr r!Zopenpyxl.worksheet._read_onlyr"Zopenpyxl.worksheet._readerr#Zopenpyxl.chartsheetr$Zopenpyxl.worksheet.tabler%Z$openpyxl.drawing.spreadsheet_drawingr&Zopenpyxl.xml.functionsr'rxr(r2r9rHrIrr7r7r7r8sF     4             !J