Ë
|
dñúhE0 ã ó® d Z ddlmZmZ ddlmZ ddlZddlZddl m
|
Z
|
ddl m Z dd lmZ dd
|
lmZmZmZmZmZmZmZmZmZmZmZ dd l m Z dd l m Z d 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/m0Z0m1Z1 ddl2m3Z3 ddl4m5Z5 ddl6m7Z7 ddl8m9Z9 ddl:m;Z; ddl<m=Z= d dl>m?Z? d Z@d ZAd ZB G d d « ZCde dd!dfd"ZDy# e $ r dZ Y w xY w)#z Read an xlsx file into Pythoné )ÚZipFileÚ ZIP_DEFLATED)ÚBytesION)ÚTableDefinitioné )ÚKEEP_VBAF)ÚInvalidFileException) ÚARC_COREÚ
|
ARC_CUSTOMÚARC_CONTENT_TYPESÚ ARC_WORKBOOKÚ ARC_THEMEÚ COMMENTS_NSÚSHARED_STRINGSÚXLTMÚXLTXÚXLSMÚXLSX)Ú
|
MergedCell)Ú CommentSheeté )Úread_string_tableÚread_rich_text)ÚWorkbookParser)Úapply_stylesheet)ÚDocumentProperties)ÚCustomPropertyList)ÚManifestÚOverride)ÚRelationshipListÚget_dependentsÚ get_rels_path)ÚReadOnlyWorksheet)ÚWorksheetReader)Ú
|
Chartsheet)ÚTable)ÚSpreadsheetDrawing)Ú
|
fromstring)Ú find_images)z.xlsxz.xlsmz.xltxz.xltmc ó> t | d« }|st j j | « d j « }|t
|
vrJ|dk( r d}t |« |dk( r d}t |« d|dd j t
|
« }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.
|
Úreadéÿÿÿÿz.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 openpyxlzopenpyxl does not support zT file format, please check you can open it with Excel first. Supported formats are: ú,Úr) ÚhasattrÚosÚpathÚsplitextÚlowerÚSUPPORTED_FORMATSÚjoinr r )ÚfilenameÚ is_file_likeÚ file_formatÚmsgÚarchives úHH:\Change_password\venv_build\Lib\site-packages\openpyxl/reader/excel.pyÚ_validate_archiver< B s¶ ô 8 VÓ,LÙ Ügg×&Ñ& xÓ0°Ñ4×:Ñ:Ó< Ø Ô /Ñ /ØfÒ$ð<ô ' sÓ+Ð +ð Ò'ð2ô ' sÓ+Ð +ð (ò 8CØ7:·x±xÔ@QÔ7Rð Tô
|
' sÓ+Ð +äh Ó$GØ Nó c ó2 t t t t g}|D ] }| j |« }|s|c S | j
|
D ch c] }|j }}|t |« z }|r!t dt z |j « « S t d« c c}w )Nú/z$File contains no valid workbook part) r r r r ÚfindÚDefaultÚ ContentTypeÚsetr r ÚpopÚIOError)ÚpackageÚworkbook_typesÚctÚpartÚpÚdefaultsÚ workbook_types r; Ú_find_workbook_partrM c s ÜD¤$¬Ð-NØ ò Ø||BÓ Ú ØKðð (/§¡Ö7 ! Ð7HÐ7Ø s >Ó 2Ñ2MÙÜlÑ*¨M×,=Ñ,=Ó,?Ó@Ð@ä
|
Ð8Ó
|
9Ð9ùò 8s ÁBc óX e Zd ZdZdedddfdZd Zd Zd Zd Z d Z
|
d
|
Z d Z d Z d Zy)Ú ExcelReaderzQ
|
Read an Excel package and dispatch the contents to the relevant modules
|
FTc ó¶ t |« | _ | j j « | _ || _ || _ || _ || _ || _ g | _ y ©N)
|
r< r: ÚnamelistÚ valid_filesÚ read_onlyÚkeep_vbaÚ data_onlyÚ
|
keep_linksÚ rich_textÚshared_strings)ÚselfÚfnrT rU rV rW rX s r; Ú__init__zExcelReader.__init__y sN ä(¨Ó, Ø <<×0Ñ0Ó2ÔØ"Ø Ø"Ø$Ø"Ø Õr= c ó | j j t « }t |« }t j
|
|« | _ y rQ )r: r+ r r( r Ú from_treerF )rZ ÚsrcÚroots r; Ú read_manifestzExcelReader.read_manifest
s2 Øll× Ñ Ô 1Ó2Ü#Ü ×)Ñ)¨$Ó/ r= c ó | j j t « }t }| j rt
|
}|A|j dd }| j j |« 5 } ||« | _ d d d « y y # 1 sw Y y xY w)Nr )
|
rF r@ r r rX r ÚPartNamer: ÚopenrY )rZ rH ÚreaderÚ strings_pathr_ s r; Ú read_stringszExcelReader.read_strings sz Ø \\× Ñ ~Ó .Ü"Ø >>Ü#FØ >Ø ;; q r?LØ ×"Ñ" <Ó1ð 2°SÙ&,¨S£kÔ#÷ 2ð 2ð ÷ 2ð 2ús Á$A<Á<Bc óª t | j « }t | j |j dd | j
|
¬« | _ | j j « | j j }g |_ | j |_ | j |_ |j t t fv |_ | j$ rdt' t) « dt* « |_ | j. D ]7 }|j, j1 || j j3 |« « 9 | j r| j |_ || _ y )Nr )rW Úa)rM rF r r: rc rW ÚparserÚparseÚwbÚ_sheetsrV Ú
|
_data_onlyrT Ú
|
_read_onlyrB r r ÚtemplaterU r r r Ú vba_archiverS Úwritestrr+ Ú_archive)rZ Úwb_partrl Únames r; Ú read_workbookzExcelReader.read_workbook sø Ü% d§l¡lÓ3Ü$ T§\¡\°7×3CÑ3CÀAÀBÐ3GÐTX×TcÑTcÔd Ø ×ÑÔØ [[^^Ø
|
Ø Ø Ø ×)Ñ)¬d´D¨\Ð9 ð ==Ü $¤W£Y°´\Ó BBNØ ×(Ñ(ò GØ×'Ñ'¨¨d¯l©l×.?Ñ.?ÀÓ.EÕFð Gð >>Ø ,,BKàr= c ó t | j v rMt | j j t « « }t j |« | j _ y y rQ ) r
|
rS r( r: r+ r r^ rl Ú
|
properties©rZ r_ s r; Úread_propertieszExcelReader.read_properties sE Ü t×'Ñ'Ñ 'Ü T\\× .Ñ .¬xÓ 8Ó9CÜ!3×!=Ñ!=¸cÓ!BDGGÕ ð (r= c óÂ t | j v rMt | j j t « « }t j |« | j _ y y rQ ) r rS r( r: r+ r r^ rl Úcustom_doc_propsry s r; Ú read_customzExcelReader.read_custom³ sE Ü ×)Ñ)Ñ )Ü T\\× .Ñ .¬zÓ :Ó;CÜ'9×'CÑ'CÀCÓ'HDGGÕ $ð *r= c ó t | j v r/| j j t « | j _ y y rQ )r rS r: r+ rl Ú loaded_theme)rZ s r; Ú
|
read_themezExcelReader.read_theme¹ s0 Ü ×(Ñ(Ñ (Ø#'§<¡<×#4Ñ#4´YÓ#?DGGÕ ð )r= c ó| |j }t |« }g }|| j v rt | j |« }| j j |d« 5 }|j « }d d d « t « }t j |« } | j | _ |j | _ | j j | « |j t j" « }
|
|
|
D ]= }t% | j |j « \ } } | D ] } | j' | « ? y # 1 sw Y ÈxY w)Nr. )Útargetr" rS r! r: rd r+ r( r% r^ rl Ú_parentru ÚtitleÚ
|
_add_sheetr@ r' Ú _rel_typer) Ú add_chart)rZ ÚsheetÚrelÚ
|
sheet_pathÚ rels_pathÚrelsr_ ÚxmlÚnodeÚcsÚdrawingsÚchartsÚimagesÚcs r; Úread_chartsheetzExcelReader.read_chartsheet¾ s ØZZ
|
Ü! *Ó- ØØ ×(Ñ(Ñ (Ü! $§,¡,° Ó:Dà \\× Ñ z¨3Ó /ð °3Ø((*C÷ ä#Ü × !Ñ ! $Ó 'ØWW
|
Ø::Ø ×Ñ2Ô à99Ô /× 9Ñ 9Ó:Øò CÜ (¨¯ © °s·z±zÓ BNFFØò Ø Qñ ñ ÷ ð ús ÁD2Ä2D;c
|
ó$ d}| j j « D ] \ }}|j | j vr d|j v r| j ||« At |j « }t « }|| j v rt | j |« }| j rmt | j |j |j | j « }|j |_ | j j" j% |« ý| j j' |j « }| j j) |j « }||_ t- ||| j | j. | j0 « }|j3 « |j5 « |j7 t8 « D ]d } | j j; | j « }
|
t= j> tA |
|
« « } | jB D ] \ } } | || _" f | j jV r7|jX r+|j[ |jX « j |_, nd |_, |j\ D ]N }| j j; |« }
|
tA |
|
« }t_ j> |« }|ja |« P |j7 tb jd « }|D ]k }tg | j |j « \ }}|D ] }|ji ||jj « |D ] }|jm ||jj « m |j7 tn jp « }| j jr }|D ]n } | jt }| j j; |« }
|
tA |
|
« }to j> |« }||jv |_< |j{ |« p |j |_ y # tF $ rU || }tI |tJ « r<tM jN |jQ |jR |jT « « Y lY ow xY w)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)>rj Ú find_sheetsr rS ÚTyper r" r r! r: rT r# rl ru rY ÚstateÚ sheet_staterm Úappendrd Ú create_sheetÚ_relsr$ rV rX Úbind_allÚcloser@ r r+ r r^ r( ÚcommentsÚcommentÚAttributeErrorÚ
|
isinstancer ÚwarningsÚwarnÚformatr Ú
|
coordinaterq Úlegacy_drawingÚgetÚtablesr& Ú add_tabler' r r) r ÚanchorÚ add_imager Úrel_typeÚ pivot_cachesÚTargetÚcacheIdÚcacheÚ add_pivot)rZ Úcomment_warningr r r r ÚwsÚfhÚ ws_parserr. r_ Ú comment_sheetÚrefr¡ r Útr Útabler r r ÚimÚ pivot_relr¯ Ú
|
pivot_pathÚtreeÚpivots r; Úread_worksheetszExcelReader.read_worksheetsÔ s© ð _Ø ++×1Ñ1Ó3ó E )JE3Øzz ×!1Ñ!1Ñ1ØàsxxÑ'Ø×$Ñ$ U¨CÔ0Øä% c§j¡jÓ1IÜ#Ó%DØD× ,Ñ ,Ñ,Ü% d§l¡l°IÓ>à~~Ü& t§w¡w°·
|
±
|
¸C¿J¹JÈ×H[ÑH[Ó\Ø!&§¡Ø×&Ñ& rÔ*Øà\\×&Ñ& s§z¡zÓ2ØWW×)Ñ)¨%¯*©*Ó5Ø Ü +¨B°°D×4GÑ4GÈÏ É ÐY]×YgÑYgÓ h Ø×"Ñ"Ô$Ø
|
ð YY{Ó+ò
|
%Øll×'Ñ'¨¯©Ó1Ü ,× 6Ñ 6´zÀ#³Ó G Ø$1×$:Ñ$:ò %LCð%Ø*13ñ%ð
|
%ð ww×"Ò" r×'8Ò'8Ø$(§H¡H¨R×->Ñ->Ó$?×$FÑ$FÕ!à$(Ô!à ×%Ñ%ò $Øll×'Ñ'¨Ó*Ü oÜ ¨Ó,Ø UÕ#ð $ð yyÔ!3×!=Ñ!=Ó>HØ ò 0Ü!,¨T¯\©\¸3¿:¹:Ó!FØ ò .AØLL A§H¡HÕ-ð.à ò 0BØLL R§Y¡YÕ/ñ0ð 0ð ¤/×":Ñ":Ó;IØ ;;×3Ñ3LØ ò $Ø XX
|
Øll×'Ñ'¨
|
Ó3Ü! #Ü'×1Ñ1°$Ó7Ø *¨5¯=©=Ñ 9 Ø UÕ#ð $ð #[[BNñKE )øôB *ò %Ø sGÜ% a¬Ô4Ü $MM¨/×*@Ñ*@ÀÇÁÈ1Ï<É<Ó*XÔ YÚ $ò 5ð%ús È&
|
P1Ð1AR ÒR c ó< d} | j « d}| j « d}| j « d}| j « d}| j « d}| j « d}t | j | j « d}| j « d }| j j « | j s| j j « y y # t $ r,}t d
|
| d | j j d « |d }~ww xY w) 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.)ra rg rv rz r} r r r: rl rÁ rj Ú assign_namesrT r Ú
|
ValueErrorr6 )rZ ÚactionÚes r; r+ zExcelReader.read s Ø ð Ø × Ñ Ô Ø#FØ × Ñ Ô Ø$FØ × Ñ Ô Ø&FØ × Ñ Ô "Ø-FØ × Ñ Ô Ø!FØ OOÔ Ø&FÜ T\\¨4¯7©7Ô 3Ø&FØ × Ñ Ô "Ø#FØ KK× $Ñ $Ô &Ø>>Ø ×"Ñ"Õ$ð "øäò Ü Ø5°f°X¸VÀDÇLÁL×DYÑDYÐCZð [=ð =óð ð ûð ús C C& Ã& DÃ/'DÄDN)Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r r\ ra rg rv rz r} r r rÁ r+ © r= r; rO rO s sL ñð &+°XØ ¨T¸Uó !ò0ò 2òò.Cò Iò @ò
|
ò,G)óTr= rO Tc óZ t | |||||« }|j « |j S )aE 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: 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.
|
|
)rO r+ rl )r6 rT rU rV rW rX re s r; Ú load_workbookrÍ < s. ô< 9¨hØ" J° ó;Fà
|
KKMØ 99Ðr= )ErÊ Úzipfiler r Úior Úos.pathr0 r¤ Úopenpyxl.pivot.tabler Útestsr Ú ImportErrorÚopenpyxl.utils.exceptionsr Úopenpyxl.xml.constantsr
|
r r r r r r r r r r Ú openpyxl.cellr Ú openpyxl.comments.comment_sheetr Ústringsr r Úworkbookr Úopenpyxl.styles.stylesheetr Úopenpyxl.packaging.corer Úopenpyxl.packaging.customr Úopenpyxl.packaging.manifestr r Ú openpyxl.packaging.relationshipr r! r" Ú openpyxl.worksheet._read_onlyr# Úopenpyxl.worksheet._readerr$ Úopenpyxl.chartsheetr% Úopenpyxl.worksheet.tabler& Ú$openpyxl.drawing.spreadsheet_drawingr' Úopenpyxl.xml.functionsr( r r) r4 r< rM rO rÍ rË r= r; ú<module>rå sÁ ðñ $÷ *Ý Û Û å 0ðÝ õ
|
;÷ ÷ ÷ ñ õ %Ý 8ç 6Ý $Ý 7å 6Ý 8ß :÷ñ õ <Ý 6Ý *Ý *Ý Cå -å !ð 9Ð ò òB :÷ Fñ FðR ',°hØ !¨d¸eô!øðW ò ØHðús C
|
Ã
|
CÃC
|
