o jE0@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)filename is_file_like file_formatmsgarchiver9Y/var/www/ticemtrilhas/avaliacao_env/lib/python3.10/site-packages/openpyxl/reader/excel.py_validate_archiveBs$    r;cCsfttttg}|D] }||}|r|Sqdd|jD}|t|@}|r/tdt| St d)NcSsh|]}|jqSr9) ContentType).0pr9r9r: ksz&_find_workbook_part../z$File contains no valid workbook part) rrrrfindDefaultsetrr popIOError)packageworkbook_typesctpartdefaults workbook_typer9r9r:_find_workbook_partcs   rLc@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) r;r8namelist valid_files read_onlykeep_vba data_only keep_links rich_textshared_strings)selffnrQrRrSrTrUr9r9r:__init__ys   zExcelReader.__init__cCs$|jt}t|}t||_dSrN)r8r)r r'r from_treerF)rWsrcrootr9r9r: read_manifests zExcelReader.read_manifestcCsp|jt}t}|jr t}|dur6|jdd}|j|}|||_ WddS1s/wYdSdS)Nr) rFrArrrUrPartNamer8openrV)rWrHreader strings_pathr[r9r9r: 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)rTa)rLrFrr8r^rTparserparsewb_sheetsrS _data_onlyrQ _read_onlyr<rrtemplaterRrrr vba_archiverPwritestrr)_archive)rWwb_partrfnamer9r9r: read_workbooks    zExcelReader.read_workbookcC0t|jvrt|jt}t||j_dSdSrN) r rPr'r8r)rrZrf propertiesrWr[r9r9r:read_properties zExcelReader.read_propertiescCrqrN) r rPr'r8r)rrZrfcustom_doc_propsrsr9r9r: read_customruzExcelReader.read_customcCs"t|jvr|jt|j_dSdSrN)r rPr8r)rf loaded_theme)rWr9r9r: 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!rPr r8r_r)r'r$rZrf_parentrotitle _add_sheetrAr& _rel_typer( add_chart)rWsheetrel sheet_path rels_pathrelsr[xmlnodecsdrawingschartsimagescr9r9r:read_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. chartsheet)>rd find_sheetsrzrPTyperr!rr r8rQr"rfrorVstate sheet_statergappendr_ create_sheet_relsr#rSrUbind_allcloserArr)rrZr'commentscommentAttributeError isinstancerwarningswarnformatr| coordinaterklegacy_drawinggettablesr% add_tabler&r~r(ranchor add_imagerrel_type pivot_cachesTargetcacheIdcache add_pivot)rWcomment_warningrrrrwsfh ws_parserr,r[ comment_sheetrefrrtrtablerrrim pivot_relr pivot_pathtreepivotr9r9r:read_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.)r]rbrprtrwryrr8rfrrd assign_namesrQr ValueErrorr4)rWactioner9r9r:r)s< zExcelReader.readN)__name__ __module__ __qualname____doc__rrYr]rbrprtrwryrrr)r9r9r9r:rMss    JrMTcCs 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. )rMr)rf)r4rQrRrSrTrUr`r9r9r: load_workbook<s r)Erzipfilerrioros.pathr.ropenpyxl.pivot.tablertestsr ImportErroropenpyxl.utils.exceptionsropenpyxl.xml.constantsr r r r r rrrrrr openpyxl.cellropenpyxl.comments.comment_sheetrstringsrrworkbookropenpyxl.styles.stylesheetropenpyxl.packaging.coreropenpyxl.packaging.customropenpyxl.packaging.manifestrropenpyxl.packaging.relationshiprr r!openpyxl.worksheet._read_onlyr"openpyxl.worksheet._readerr#openpyxl.chartsheetr$openpyxl.worksheet.tabler%$openpyxl.drawing.spreadsheet_drawingr&openpyxl.xml.functionsr'rr(r2r;rLrMrr9r9r9r:sJ    4            !J