o ϩZhE0@sdZddlmZmZddlmZddlZddlZddl m Z zddl m Z Wn e y1dZ Ynwdd 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.xltmcCszt|d}|s6tj|d}|tvr6|dkrd}t||dkr)d}t|d|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_formatmsgarchiver7L/var/www/html/lang_env/lib/python3.10/site-packages/openpyxl/reader/excel.py_validate_archiveBs$    r9cCsfttttg}|D] }||}|r|Sqdd|jD}|t|@}|r/tdt| St d)NcSsh|]}|jqSr7) ContentType).0pr7r7r8 ksz&_find_workbook_part../z$File contains no valid workbook part) rrrrfindZDefaultsetrr popIOError)packageZworkbook_typesctpartdefaultsZ workbook_typer7r7r8_find_workbook_partcs   rGc@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)selffnrLrMrNrOrPr7r7r8__init__ys   zExcelReader.__init__cCs$|jt}t|}t||_dSrI)r6r)r r'r from_treerC)rRsrcrootr7r7r8 read_manifests zExcelReader.read_manifestcCsp|jt}t}|jr t}|dur6|jdd}|j|}|||_ WddS1s/wYdSdS)Nr) rCr?rrrPrPartNamer6openrQ)rRrDreaderZ strings_pathrVr7r7r8 read_stringss  "zExcelReader.read_stringscCst|j}t|j|jdd|jd|_|j|jj}g|_ |j |_ |j |_ |jttfv|_|jrLttdt|_|jD] }|j||j|q>|j rS|j|_||_dS)Nr)rOa)rGrCrr6rYrOparserparsewb_sheetsrNZ _data_onlyrLZ _read_onlyr:rrtemplaterMrrr vba_archiverKwritestrr)Z_archive)rRZwb_partr`namer7r7r8 read_workbooks    zExcelReader.read_workbookcC0t|jvrt|jt}t||j_dSdSrI) r rKr'r6r)rrUr` propertiesrRrVr7r7r8read_properties zExcelReader.read_propertiescCrgrI) r rKr'r6r)rrUr`Zcustom_doc_propsrir7r7r8 read_customrkzExcelReader.read_customcCs"t|jvr|jt|j_dSdSrI)r rKr6r)r`Z loaded_theme)rRr7r7r8 read_themes zExcelReader.read_themecCs|j}t|}g}||jvrt|j|}|j|d }|}Wdn1s*wYt|}t |} |j | _ |j | _ |j | |tj} | D]}t|j|j\} } | D]} | | q[qNdS)Nr,)targetr!rKr r6rZr)r'r$rUr`_parentretitleZ _add_sheetr?r& _rel_typer( add_chart)rRsheetrelZ sheet_path rels_pathrelsrVxmlnodecsdrawingschartsimagescr7r7r8read_chartsheets(       zExcelReader.read_chartsheetc Csd}|jD]7\}}|j|jvrqd|jvr|||qt|j}t}||jvr2t|j |}|j rLt |j |j |j|j}|j|_|j j|q|j |j}|j |j }||_t|||j|j|j}|||tD]>} |j | j} tt | } | j!D]*\} } z| || _"Wqt#y|| }t$|t%rt&'|(|j)|j*YqYqwqu|j j+r|j,r|-|j,j|_,nd|_,|j.D]}|j |} t | }t/|}|0|q|t1j2}|D]$}t3|j |j\}}|D] }|4||j5q|D] }|6||j5qq|t7j8}|jj9}|D] } | j:}|j |} t | }t7|}||j;|_<|=|q|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_sheetsrnrKTyper~r!rr r6rLr"r`rerQstateZ sheet_stateraappendrZZ create_sheetZ_relsr#rNrPZbind_allcloser?rr)rrUr'commentscommentAttributeError isinstancerwarningswarnformatrpZ coordinatercZlegacy_drawinggetZtablesr%Z add_tabler&rqr(rranchorZ add_imagerZrel_type pivot_cachesZTargetZcacheIdcacheZ add_pivot)rRZcomment_warningrsrtrurvwsfhZ ws_parserr,rVZ comment_sheetrefrr}trwtablerzr{r|ZimZ pivot_relrZ pivot_pathtreeZpivotr7r7r8read_worksheetss~                   zExcelReader.read_worksheetsc Csd}zF|d}|d}|d}|d}|d}|d}t|j|jd}| d }|j |j sF|j WdSWdStyb}ztd |d |jjd |d}~ww) 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.)rXr\rfrjrlrmrr6r`rr^Z assign_namesrLr ValueErrorr4)rRactioner7r7r8r)s< zExcelReader.readN)__name__ __module__ __qualname____doc__rrTrXr\rfrjrlrmr~rr)r7r7r7r8rHss    JrHTcCs 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. )rHr)r`)r4rLrMrNrOrPr[r7r7r8 load_workbook<s r)ErzipfilerriorZos.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'rzr(r2r9rGrHrr7r7r7r8sJ    4            !J