Ë
|
nñúhF ã óÎ d dl mZ d dlmZmZ d dlZd dlmZm Z m
|
Z
|
m Z d dl m Z d dlmZ d dlZd dlmZ d dlmZ er d d lmZ d d
|
lmZ eed ¬ « G d ded « « Zy)é )Ú annotations)Ú TYPE_CHECKINGÚcastN)ÚFilePathÚ
|
ReadBufferÚScalarÚStorageOptions)Úimport_optional_dependency)Údoc)Ú _shared_docs)ÚBaseExcelReader©Ú OpenDocument)ÚNaTTypeÚstorage_options)r c ó¼ e Zd Z d d fd Zedd« Z ddZedd« Zedd« ZddZ ddZ
|
d ddZ dd Z dd
|
Z dd Zdd Z xZS )Ú ODFReaderc ó@ t d« t | |||¬« y)aF
|
Read tables out of OpenDocument formatted files.
|
|
Parameters
|
----------
|
filepath_or_buffer : str, path to be parsed or
|
an open readable stream.
|
{storage_options}
|
engine_kwargs : dict, optional
|
Arbitrary keyword arguments passed to excel engine.
|
Úodf)r Ú engine_kwargsN)r
|
ÚsuperÚ__init__)ÚselfÚfilepath_or_bufferr r Ú __class__s úMH:\Change_password\venv_build\Lib\site-packages\pandas/io/excel/_odfreader.pyr zODFReader.__init__ s( ø ô" # 5Ô)Ü ÑØ Ø +Ø'ð õ
|
ó c ó ddl m} |S )Nr r )Úodf.opendocumentr )r r s r Ú_workbook_classzODFReader._workbook_class8 s å1àÐr c ó ddl m} ||fi |¤S )Nr )Úload)r r" )r r r r" s r Ú load_workbookzODFReader.load_workbook> s õ *áÐ&Ñ8¨-Ñ8Ð8r c ó y)z'Property for compat with other readers.Ú © )r s r Ú empty_valuezODFReader.empty_valueE s ð r c ó ddl m} | j j |« }|D cg c] }|j d« c}S c c}w )z4Return a list of sheet names present in the documentr ©ÚTableÚname)Ú odf.tabler* ÚbookÚgetElementsByTypeÚ getAttribute)r r* ÚtablesÚts r Ú sheet_nameszODFReader.sheet_namesJ s8 õ $à×,Ñ,¨UÓ3Ø06Ö7¨1vÕ&Ò7Ð7ùÒ7s ¦Ac óp ddl m} | j |« | j j |« }|| S )Nr r) )r, r* Úraise_if_bad_sheet_by_indexr- r. )r Úindexr* r0 s r Úget_sheet_by_indexz ODFReader.get_sheet_by_indexR s1 Ý#à ×(Ñ(¨Ô/Ø×,Ñ,¨UÓ3Øe}Ð r c óâ ddl m} | j |« | j j |« }|D ] }|j d« |k( s|c S | j « t d| d« )Nr r) r+ zsheet z
|
not found)r, r* Úraise_if_bad_sheet_by_namer- r. r/ ÚcloseÚ
|
ValueError)r r+ r* r0 Útables r Úget_sheet_by_namezODFReader.get_sheet_by_nameY sm Ý#à ×'Ñ'¨Ô-Ø×,Ñ,¨UÓ3àò EØ×!Ñ! &Ó)¨TÓ1Ø ð ð
|
|
Ü6 $ zÐ2Ó3Ð3r c óð ddl m}m}m} |« j } |« j }||h}|j |« } d}
|
d} g } | D ]a } | j D cg c] }t |d« r|j |v r| }}d}g |D ] }|j |k( r| j |« }n | j }| j |« }|| j k( r||z }Vj | j g|z « d}j |g|z « | t « k r t « } | j | « }t « dk( r|
|
|z }
|
nE| j | j gg|
|
z « d}
|
| j fdt |« D « « |Rt | « |k\ sb n | D ]< }t |« | k s|j | j g| t |« z
|
z « > | S c c}w )z9
|
Parse an ODF Table into a list of lists
|
r )ÚCoveredTableCellÚ TableCellÚTableRowÚqnamec 3 ó" K | ] } y w©Nr& )Ú.0Ú_Ú table_rows r ú <genexpr>z+ODFReader.get_sheet_data.<locals>.<genexpr> s øè ø Ò B¨1YÑ Bùs )r, r> r? r@ rA r. Ú
|
childNodesÚhasattrÚ_get_cell_valuer' Ú_get_column_repeatÚextendÚlenÚ_get_row_repeatÚrange)r ÚsheetÚfile_rows_neededr> r? r@ Úcovered_cell_nameÚtable_cell_nameÚ
|
cell_namesÚ
|
sheet_rowsÚ
|
empty_rowsÚ max_row_lenr; Ú sheet_rowÚxÚ sheet_cellsÚ empty_cellsÚ
|
sheet_cellÚvalueÚ column_repeatÚ
|
row_repeatÚrowrF s @r Úget_sheet_datazODFReader.get_sheet_dataf s ø ÷
|
ñ
|
ñ -Ó .× 4Ñ 4ÐÙ#+×+Ñ+Ø'¨ Ð9
|
à×,Ñ,¨XÓ6
|
Ø
|
Ø à.0à#ó % Ið #×-Ñ-öàÜ1gÔ&¨1¯7©7°jÑ+@ò ðKð ð
|
KØ02Ià )ò >
|
Ø ×#Ñ# Ò6Ø × 0Ñ 0°Ó <Eà × ,Ñ ,Eà $× 7Ñ 7¸
|
Ó C ð D× ,Ñ ,Ò,Ø =Ñ0Kà ×$Ñ$ d×&6Ñ&6Ð%7¸+Ñ%EÔFØ"#KØ ×$Ñ$ e W¨}Ñ%<Õ=ð >ð S ^Ò+Ü ! )n à ×-Ñ-¨iÓ8JÜ9~ Ò"ØjÑ(
|
ð t× /Ñ /Ð 0Ð 1°JÑ >Ô?Ø
|
Ø Ó B´°jÓ0AÔ BÔBØ Ò+´°E³
|
Ð>NÔ0NÙðK% ðP ò JCÜ3x+Ó%Ø
|
|
D× ,Ñ ,Ð-°¼sÀ3»xÑ1GÑHÕIð Jð ùòWs Á #G3c ó\ ddl m} t |j j |dfd« « S )z«
|
Return number of times this row was repeated
|
Repeating an empty row appeared to be a common way
|
of representing sparse rows in the table.
|
r ©ÚTABLENSznumber-rows-repeatedé ©Úodf.namespacesrd ÚintÚ
|
attributesÚget)r r` rd s r rN zODFReader._get_row_repeatª s) õ +ä3>>×%Ñ% wÐ0FÐ&GÈÓKÓLÐLr c ó\ ddl m} t |j j |dfd« « S )Nr rc znumber-columns-repeatedre rf )r Úcellrd s r rK z ODFReader._get_column_repeat´ s' Ý*ä4??×&Ñ&¨Ð1JÐ'KÈQÓOÓPÐPr c óT ddl m} t |« dk( rt j S |j
|
j |df« }|dk( rt |« dk( ryy| | j S |d k( r:t |j
|
j |d
|
f« « }t |« }||k( r|S |S |d k( r(|j
|
j |d
|
f« }t |« S |d k( r| j |« S |d k( r(|j
|
j |d
|
f« }t |« S |dk( r2|j
|
j |df« }t j |« S |dk( r<t j t |« « }t t |j « « S | j! « t# d| « )Nr )ÚOFFICENSz#N/Az
|
value-typeÚbooleanÚTRUETFÚfloatr] Ú
|
percentageÚstringÚcurrencyÚdatez
|
date-valueÚtimezUnrecognized type )rg rn ÚstrÚnpÚnanri rj r' rq rh Ú_get_cell_string_valueÚpdÚ Timestampr r rv r9 r: )r rl rn Ú cell_typeÚ
|
cell_valueÚvalÚstamps r rJ zODFReader._get_cell_value¹ s Ý+ä t9Ò Ü66MàOO×'Ñ'¨°<Ð(@ÓA Ø Ò !Ü4yFÒ"ØØØ Ð Ø×#Ñ#Ð #Ø 'Ò !ä t× 2Ñ 2°H¸gÐ3FÓ GÓHJÜj/CØjÒ Ø
|
Ø Ð Ø ,Ò &Ø ×,Ñ,¨h¸Ð-@ÓAJÜÓ$Ð $Ø (Ò "Ø×.Ñ.¨tÓ4Ð 4Ø *Ò $Ø ×,Ñ,¨h¸Ð-@ÓAJÜÓ$Ð $Ø &Ò Ø ×,Ñ,¨h¸ Ð-EÓFJÜ<<
|
Ó+Ð +Ø &Ò ÜLL¤ T£Ó+Eä §
|
¡
|
£ Ó-Ð -à JJLÜ Ð 1°)°Ð =Ó>Ð >r c ó ddl m} ddlm} ddlm} ddlm} |« j } |« j }g }|j D ]³ } t | |« r|| j |k( r<t | j j |dfd« « }
|
|j d|
|
z « Z| j |k( rj|j | j | « « |j t! | « j# d « « µ d
|
j% |« S ) z
|
Find and decode OpenDocument text:s tags that represent
|
a run length encoded sequence of space characters.
|
r )ÚElement)ÚTEXTNS)Ú
|
Annotation)ÚSÚcre ú ú
|
r% )Ú odf.elementr rg r Ú
|
odf.officer Úodf.textr
rA rH Ú
|
isinstancerh ri rj Úappendrz rw ÚstripÚjoin) r rl r r r r
Úoffice_annotationÚtext_sr] ÚfragmentÚspacess r rz z ODFReader._get_cell_string_valueà sÜ õ
|
(Ý)Ý)Ý á &L× .Ñ .ÐÙàà ò 8HÜ( GÔ,Ø>> VÒ+Ü ×!4Ñ!4×!8Ñ!8¸&À#¸ ÈÓ!JÓ KFØLL v¡ Õ.Ø ^^Ð'8Ò8Ø ð
|
LL ×!<Ñ!<¸XÓ!FÕGà S ]× 0Ñ 0°Ó 6Õ7ð 8ð wwu~Ð r )NN)r ú FilePath | ReadBuffer[bytes]r zStorageOptions | Noner z dict | NoneÚreturnÚNone)r ztype[OpenDocument])r r r r )r rw )r z list[str])r5 rh )r+ rw rC )rQ z
|
int | Noner z list[list[Scalar | NaTType]])r rh )r zScalar | NaTType)Ú__name__Ú
|
__module__Ú __qualname__r Úpropertyr r# r' r2 r6 r< ra rN rK rJ rz Ú __classcell__)r s @r r r sÆ ø ð
|
26Ø%)ð
|
à 8ð
|
ð /ð
|
ð #ð
|
ð
|
|
õ
|
ð0 ò ó ð ð
|
9Ø">ð9à ó9ð òó ðð ò8ó ð8ó ó 4ð 59ðBØ'1ðBà %óBóHMóQó
|
%?÷N r r r )Ú
|
__future__r Útypingr r Únumpyrx Úpandas._typingr r r r Úpandas.compat._optionalr
|
Úpandas.util._decoratorsr Úpandasr{ Úpandas.core.shared_docsr Úpandas.io.excel._baser r r Úpandas._libs.tslibs.nattyper r r& r r ú<module>r¦ sd ðÝ "÷ó
|
÷ó õ ?Ý 'ã Ý 0å 1áÝ-å3ñ \Ð"3Ñ4Ô5ô^ Ñ/ó ^ ó 6ñ^ r
|
