^Q\&@sVddlmZddlmZmZmZddlmZddlm Z ddl Z ddl Z ddl mZmZddlmZydd lmZWnek rd ZYnXdd lmZdd lmZmZmZmZmZmZmZmZm Z m!Z!m"Z"m#Z#dd l$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/m0Z0ddl1m2Z2ddl3m4Z4m5Z5ddl6m7Z7ddl8m9Z9ddl:m;Z;ddl<m=Z=ddl>m?Z?ddl@mAZAdZBd*ZCd!d"ZDd#d$ZEd%d&ZFd ed d d'd(d)ZGdS)+)absolute_import)ZipFile ZIP_DEFLATED BadZipfile)exc_info)BytesION)unicodefile)TableDefinition)KEEP_VBAF)InvalidFileException) ARC_SHARED_STRINGSARC_COREARC_CONTENT_TYPES ARC_WORKBOOK ARC_THEME COMMENTS_NSSHARED_STRINGS EXTERNAL_LINKXLTMXLTXXLSMXLSX) CommentSheet)Workbook)read_string_table)apply_stylesheet)DocumentProperties)ManifestOverride)WorkbookParser)get_dependents get_rels_path)ReadOnlyWorksheet)Table)SpreadsheetDrawing) find_charts) fromstring)WorkSheetParsersPK.xlsx.xlsm.xltx.xltmcCs|r |n t|d}|j}|jt}|dkrzt|}|j|d|j|jd|S|jd|S)z trims trailing data from the central directory code taken from http://stackoverflow.com/a/7457686/570216, courtesy of Uri Cohen zrb+r)openreadfindCENTRAL_DIRECTORY_SIGNATURErseektruncate)ZzipFileZis_file_instancefdatapossior:J/var/www/dbchiro/venv/lib/python3.4/site-packages/openpyxl/reader/excel.pyrepair_central_directoryDs      r<c Cs%t|d}| rtjj|rtjj|d j}|tkr|dkred}n.|dkrzd}nd|djtf}t|qn|rt |d d d k rt d qnyt |d t }Wn3t k r t||}t |d t }YnX|S)z+ Check the file is a valid zipfile r1rz.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,encodingNz)File-object must be opened in binary moder)hasattrospathisfilesplitextlowerSUPPORTED_FORMATSjoinr getattrIOErrorrrrr<)filenameZ is_file_likeZ file_formatmsgarchiver6r:r:r;_validate_archiveXs*      rNcCsttttg}x'|D]}|j|}|r|SqWtdd|jD}|t|@}|rtdt|j St ddS)Ncss|]}|jVqdS)N) ContentType).0pr:r:r; sz&_find_workbook_part../z$File contains no valid workbook part) rrrrr2setZDefaultr!rpoprJ)packageZworkbook_typesctpartdefaultsZ workbook_typer:r:r;_find_workbook_parts rZTc)Cst|}|}|jt}t|}tj|} t| } t|| jdd} | j } || _ || _ || _ || _ | jttfk| _| jg| _|r|rtjdn|j} |r8ttdt| _x3|jD]"}| jj||j|qWn|rPt|| _nt| krt|jt}tj|| _ng}| j t!}|dk r|jdd}t"|j|}nt#| kr|jt#| _$nt%|| | j&}x| j'D]\}}|j(}|j)}t*|}g}|| krdt+||}n|| krvqn|rt,| ||d|}| jj-|n|j.|}| j/|}||_0t1|||}|j|rxe|j t2D]T}|j|j)}t3jt|}x$|j4D]\}}|||_5q7WqW| jdk r|j6dk r||j6j)|_6nxH|j7D]=} |j| }t|}!t8j|!}"|j9|"qW|j t:j;}#x>|#D]6}x-t<||j)D]}$|j=|$|$j>q WqW|j t?j@}%xa|%D]V}|jA}&|j|&}t|}'t?j|'}(||(jB|(_C|jD|(qCWn|jE|_Fg|_0qW| jG|jH| S)a#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: preseve vba content (this does NOT mean you can use it) :type keep_vba: bool :param guess_types: guess cell content type and do not read it from the file :type guess_types: 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 :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. rNz5Data types are not guessed when using iterator readera)IrNr1rr)r Z from_treerZr"ZPartNamewbZ _data_onlyZ _read_onlyZ _keep_links guess_typesrOrrtemplateparseZ_sheetswarningswarnnamelistrrrZ vba_archivewritestrZ_archiverrZ propertiesr2rrrZ loaded_themer pivot_cachesZ find_sheetsnametargetr$r#r%appendr0Z create_sheetZ_relsr*rrZcommentscommentZlegacy_drawingZtablesr&Z add_tabler'Z _rel_typer(Z add_chartanchorr Zrel_typeZTargetZcacheIdcacheZ add_pivotstateZ sheet_stateZ assign_namesclose))rKZ read_onlyZkeep_vbaZ data_onlyr]Z keep_linksrMsrcrootrVZwb_partparserr\Z valid_filesreZshared_stringsrWZ strings_pathrdZsheetrelZ sheet_nameZworksheet_pathZ rels_pathZrelswsZfhZ ws_parserr?Z comment_sheetrefrhtZxmltableZdrawingscZ pivot_relZ pivot_pathtreeZpivotr:r:r; load_workbooks            #                      rw)r+r,r-r.)H __future__rzipfilerrrsysrioros.pathrBr`Zopenpyxl.compatrr Zopenpyxl.pivot.tabler Ztestsr ImportErrorZopenpyxl.utils.exceptionsr Zopenpyxl.xml.constantsrrrrrrrrrrrrZopenpyxl.comments.comment_sheetrZopenpyxl.workbookrstringsrZopenpyxl.styles.stylesheetrZopenpyxl.packaging.corerZopenpyxl.packaging.manifestr r!Zopenpyxl.packaging.workbookr"Zopenpyxl.packaging.relationshipr#r$Zopenpyxl.worksheet.read_onlyr%Zopenpyxl.worksheet.tabler&Z$openpyxl.drawing.spreadsheet_drawingr'Zopenpyxl.chart.readerr(Zopenpyxl.xml.functionsr)Z worksheetr*r3rGr<rNrZrwr:r:r:r;sD    R  (