U \$d/@sdZddlmZmZddlmZddlZddlZddl m Z zddl m Z Wne k rddZ YnXdd 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}|tkr`|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_formatmsgarchiver79/tmp/pip-unpacked-wheel-dtxbr_v9/openpyxl/reader/excel.py_validate_archiveBs  r9cCsjttttg}|D]}||}|r|Sqdd|jD}|t|@}|r^tdt| St ddS)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_manifestc CsV|jt}t}|jrt}|dk rR|jdd}|j|}|||_ W5QRXdS)Nr) rCr?rrrPrPartNamer6openrQ)rRrDreaderZ strings_pathrVr7r7r8 read_stringss zExcelReader.read_stringscCst|j}t|j|jdd|jd|_|j|jj}g|_ |j |_ |j |_ |jttfk|_|jrttdt|_|jD]}|j||j|q||j r|j|_||_dS)Nr)rOa)rGrCrr6rYrOparserparsewb_sheetsrNZ _data_onlyrLZ _read_onlyr:rrtemplaterMrrr vba_archiverKwritestrr)Z_archive)rRZwb_partr`namer7r7r8 read_workbooks   zExcelReader.read_workbookcCs,t|jkr(t|jt}t||j_dSrI) r rKr'r6r)rrUr`Z propertiesrRrVr7r7r8read_propertiess zExcelReader.read_propertiescCs,t|jkr(t|jt}t||j_dSrI) r rKr'r6r)rrUr`Zcustom_doc_propsrgr7r7r8 read_customs zExcelReader.read_customcCst|jkr|jt|j_dSrI)r rKr6r)r`Z loaded_theme)rRr7r7r8 read_themes zExcelReader.read_themec Cs|j}t|}g}||jkr(t|j|}|j|d}|}W5QRXt|}t |} |j | _ |j | _ |j | |tj} | D]*}t|j|j\} } | D]} | | qqdS)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]x\}}|j|jkr&qd|jkr>|||qt|j}t}||jkrdt|j |}|j rt |j |j |j|j}|j|_|j j|qn@|j |j}|j |j }||_t|||j|j|j}||tD]} |j | j} tt| } | j D]`\} } z| || _!WnFt"k rf|| }t#|t$rbt%&|'|j(|j)Yq YnXq q|j j*r|j+r||j+j|_+nd|_+|j,D].}|j |} t| }t-|}|.|q|t/j0}|D]L}t1|j |j\}}|D]}|2||j3q|D]}|4||j3qq|t5j6}|D]D} | j7}|j |} t| }t5|}|jj8|j9|_:|;|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)tk r}z td |d |jjd |W5d}~XYnXdS) 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\rfrhrirjrr6r`rr^Z assign_namesrLclose ValueErrorr4)rRactioner7r7r8r)s6 zExcelReader.readN)__name__ __module__ __qualname____doc__rrTrXr\rfrhrirjr{rr)r7r7r7r8rHss  HrHTcCs 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:sr)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'rwr(r2r9rGrHrr7r7r7r8sJ    4             !H