Ë
|
dñúhM ã ób d Z ddlmZ ddlmZmZ ddlmZ ddlm Z ddl
|
m Z d Z G d d
|
« Z y ) z Read worksheets on-demand
|
é )Ú Worksheeté )Ú ReadOnlyCellÚ
|
EMPTY_CELL)Úget_column_letter)ÚWorkSheetParser)ÚDefinedNameDictc ó: t | g « }|j « S ©N)r Úparse_dimensions)ÚsourceÚparsers úPH:\Change_password\venv_build\Lib\site-packages\openpyxl/worksheet/_read_only.pyÚread_dimensionr s Ü V RÓ (FØ × "Ñ "Ó $Ð$ó c ó( e Zd ZdZdZdxZZej Zej Z ej Z
|
ej Z ej Z ej Z d Zd Zd ZddZddZd Zdd Zd
|
Zd Zed « Zed « Zed « Zed « Zy)ÚReadOnlyWorksheetr Nc ó || _ || _ d| _ d | _ || _ || _ | j « t « | _ y )NÚvisible) ÚparentÚtitleÚ sheet_stateÚ _current_rowÚ_worksheet_pathÚ_shared_stringsÚ _get_sizer Ú defined_names)ÚselfÚparent_workbookr Úworksheet_pathÚshared_stringss r Ú__init__zReadOnlyWorksheet.__init__# sE Ø% Ø
|
Ø$ÔØ ÔØ -Ô Ø -Ô Ø ÔÜ ,Ó .Õr c ó¸ | j « }t |g « }|j « }|j « | |\ | _ | _ | _ | _ y y r )Ú _get_sourcer r ÚcloseÚ _min_columnÚ_min_rowÚ _max_columnÚ_max_row)r Úsrcr Ú
|
dimensionss r r zReadOnlyWorksheet._get_size. sV Ø× Ñ Ó Ü bÓ)Ø×,Ñ,Ó.
|
Ø Ø Ð !ØOYÑ LDÔ dm¨TÔ-=¸t½}ð "r c ó` | j j j | j « S )z0Parse xml source on demand, must close after use)r Ú_archiveÚopenr ©r s r r$ z ReadOnlyWorksheet._get_source7 s# à{{×#Ñ#×(Ñ(¨×)=Ñ)=Ó>Ð>r c # ó¦ K t }|rd}|xs | j }|xs | j }g }| |f|dz |z
|
z }|}d} | j « 5 }
|
t |
|
| j
|
| j j | j j | j j | j j ¬« } | j « D ]K \ } } || |kD r n?t || « D ] } |dz }| || k s/| j | |||« } |dz }| M ddd« | || k rt ||dz « D ] } | yyy# 1 sw Y +xY ww)zt
|
The source worksheet file may have columns or rows missing.
|
Missing cells will be created.
|
Nr )Ú data_onlyÚepochÚ date_formatsÚtimedelta_formats)r Ú
|
max_columnÚmax_rowr$ r r r r1 r2 Ú _date_formatsÚ_timedelta_formatsÚparseÚrangeÚ_get_row)r Úmin_colÚmin_rowÚmax_colr6 Ú values_onlyÚfillerÚ empty_rowÚcounterÚidxr* r ÚrowÚ_s r Ú _cells_by_rowz ReadOnlyWorksheet._cells_by_row< sw è ø ô
|
Ù ØFàÒ,T__ØÒ)T\\Ø Ø Ð Ø W¨q¡[°7Ñ%:Ñ;IàØØ × Ñ Ó ð 3Ü$ SØ%)×%9Ñ%9Ø/3¯{©{×/DÑ/DØ+/¯;©;×+<Ñ+<Ø26·+±+×2KÑ2KØ7;·{±{×7UÑ7Uô WFð #LLNò SØÐ&¨3°ª=Ùô w¨Ó,ò $AØqLGØ#Oð$ð
|
c>Ø --¨¨W°g¸{ÓKCØqLGØ Ið ÷ ð. Ð 7¨S¢=Ü7 G¨A¡IÓ.ò Ø ñ ð $1Ð ÷/ ð üs% AEÁB*EÃ< EÄ*EÅEÅ
|
Ec óâ |s|sy|xs |d d }|dz |z
|
}t g|z }|rdg|z }|D ]5 }|d }||cxk r|k sn ||z
|
} |d || < |r't | fi |¤|| < 7 t |« S )zT
|
Make sure a row contains always the same number of cells or values
|
© éÿÿÿÿÚcolumnr NÚvalue)r r Útuple)
|
r rD r< r> r? Ú row_widthÚnew_rowÚcellrB rC s
|
r r; zReadOnlyWorksheet._get_rowi s¦ ñ 7ØàÒ/c "g hÑ /ØaK 'Ñ) ä , Ñ*Ù ØfyÑ(Gàò >DØ8nGØ'Ô, WÖ,Ø Ñ'Ø # G} Ú"Ü#/°Ñ#=¸Ñ#=GCLð >ô W~Ð r c óR | j ||||« D ] }|s|d c S t S )z4Cells are returned by a generator which can be emptyr )rF r )r rD rJ s r Ú _get_cellzReadOnlyWorksheet._get_cell s6 à×%Ñ% f¨c°6¸3Ó?ò CÚØ1v ð ô Ðr c ó
|
t | j | j g« s |r| j « n t d« t | j « | j dt | j « | j S )Nz9Worksheet is unsized, use calculate_dimension(force=True)ú:)Úallr5 r6 Ú_calculate_dimensionÚ
|
ValueErrorr Ú
|
min_columnr= )r Úforces r Úcalculate_dimensionz%ReadOnlyWorksheet.calculate_dimension so ÜDOO T§\¡\Ð2Ô3ÙØ×)Ñ)Õ+ä Ð!\Ó]Ð]Ü# D§O¡OÓ4Ð5°d·l±l°^À1ÔEVÐW[×WfÑWfÓEgÐDhÐim×iuÑiuÐhvÐwÐwr c ó d}| j D ] }|s|d }t ||j « }" j | _ || _ y)z
|
Loop through all the cells to get the size of a worksheet.
|
Do this only if it is explicitly requested.
|
r rI N)ÚrowsÚmaxrJ rD r) r( )r r> ÚrrO s r rU z&ReadOnlyWorksheet._calculate_dimension sP ð Øò 0AÙØØR5DÜ' 4§;¡;Ó/Gð 0ð Ø"Õr c ó dx| _ | _ y)zÈ
|
Remove worksheet dimensions if these are incorrect in the worksheet source.
|
NB. This probably indicates a bug in the library or application that created
|
the workbook.
|
N)r) r( r/ s r Úreset_dimensionsz"ReadOnlyWorksheet.reset_dimensions¤ s ð ,0Ð/ Õ(r c ó | j S r )r' r/ s r r= zReadOnlyWorksheet.min_row ó à}}Ð r c ó | j S r )r) r/ s r r6 zReadOnlyWorksheet.max_row² ra r c ó | j S r )r& r/ s r rW z ReadOnlyWorksheet.min_column· ó à× Ñ Ð r c ó | j S r )r( r/ s r r5 z ReadOnlyWorksheet.max_column¼ rd r )F)r NF) Ú__name__Ú
|
__module__Ú __qualname__r& r' r( r) r rO Ú iter_rowsÚvaluesr[ Ú __getitem__Ú__iter__r" r r$ rF r; rQ rY rU r_ Úpropertyr= r6 rW r5 rH r r r r sÖ àKØHØ !Ð!K(ð >>DØ×#Ñ#IØ × Ñ FØ >>DØ×'Ñ'KØ×!Ñ!Hò/òZò?ó
|
* óZ ò2óxò#ò"0ð ñ ó ð ð ñ ó ð ð ñ ó ð ð ñ ó ñ r r N)Ú__doc__Ú worksheetr Úopenpyxl.cell.read_onlyr r Úopenpyxl.utilsr Ú_readerr Ú openpyxl.workbook.defined_namer r r rH r r ú<module>rt s, ðñõ !ß <Ý ,å $Ý :ò%÷
|
k ò k r
|
