Ë
|
dñúh ã ó0 d dl m Z ddlmZ G d d« Zy)é )Úcopyé )Ú Worksheetc ó. e Zd ZdZd Zd Zd Zd Zd Zy)Ú WorksheetCopyz
|
Copy the values, styles, dimensions, merged cells, margins, and
|
print/page setup from one worksheet to another within the same
|
workbook.
|
c ó@ || _ || _ | j « y ©N)ÚsourceÚtargetÚ_verify_resources)ÚselfÚsource_worksheetÚtarget_worksheets úLH:\Change_password\venv_build\Lib\site-packages\openpyxl/worksheet/copier.pyÚ__init__zWorksheetCopy.__init__ s Ø& Ø& Ø × Ñ Õ ó c ó8 t | j t « s%t | j t « s t d« | j | j u r t d« | j j | j j k7 r t d« y )NzCan only copy worksheetsz!Cannot copy a worksheet to itselfz7Cannot copy between worksheets from different workbooks)Ú
|
isinstancer
|
r r Ú TypeErrorÚ
|
ValueErrorÚparent©r s r r z WorksheetCopy._verify_resources ss ä4;;¬ Ô2Ü t{{¬IÔ6ÜÐ 6Ó7Ð 7à ;;$++Ñ %Ü Ð @ÓAÐ Aà ;;× Ñ §¡×!3Ñ!3Ò 3Ü Ð VÓWÐ Wð 4r c ól | j « | j « t | j j « | j
|
_ t | j j « | j
|
_ t | j j « | j
|
_ t | j j « | j
|
_ t | j j « | j
|
_ t | j j « | j
|
_
|
y r ) Ú _copy_cellsÚ_copy_dimensionsr r
|
Ú sheet_formatr Úsheet_propertiesÚ merged_cellsÚ page_marginsÚ
|
page_setupÚ print_optionsr s r Úcopy_worksheetz WorksheetCopy.copy_worksheet# s¼ Ø ×ÑÔØ × Ñ Ô ä#'¨¯ © ×(@Ñ(@Ó#A Ô Ü'+¨D¯K©K×,HÑ,HÓ'I Ô$Ü#'¨¯ © ×(@Ñ(@Ó#A Ô Ü#'¨¯ © ×(@Ñ(@Ó#A Ô Ü!% d§k¡k×&<Ñ&<Ó!= Ô Ü$(¨¯©×)BÑ)BÓ$C Õ!r c óÆ | j j j « D ]º \ \ }}}| j j ||¬« }|j
|
|_ |j |_ |j rt |j « |_ |j rt |j « |_ |j s¡t |j « |_ ¼ y )N)ÚcolumnÚrow) r
|
Ú_cellsÚitemsr ÚcellÚ_valueÚ data_typeÚ has_styler Ú_styleÚ hyperlinkÚ
|
_hyperlinkÚcomment)r r% ÚcolÚ source_cellÚ target_cells r r zWorksheetCopy._copy_cells/ s¸ Ø(,¯ © ×(:Ñ(:×(@Ñ(@Ó(Bò @Ñ #JS# Ø ++×*Ñ*°#¸3Ð*Ó?Kà!,×!3Ñ!3KÔ Ø$/×$9Ñ$9KÔ !à×$Ò$Ü%)¨+×*<Ñ*<Ó%= Ô"à×$Ò$Ü)-¨k×.CÑ.CÓ)D Ô&à×"Ó"Ü&*¨;×+>Ñ+>Ó&? Õ#ñ @r c óÞ dD ]h }t | j |« }t | j |« }|j « D ]' \ }}t |« ||< | j || _ ) j y )N)Úrow_dimensionsÚcolumn_dimensions)Úgetattrr
|
r r' r Ú worksheet)r ÚattrÚsrcr ÚkeyÚdims r r z WorksheetCopy._copy_dimensions@ sg Ø;ò 4DÜ$++ tÓ,CÜ T[[¨$Ó/FØ IIKò 4SÜ " 3is Ø(,¯ © s Õ%ñ 4ñ 4r N) Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r r r" r r © r r r r s# ñò !ò
|
Xò Dò@ó"4r r N)r r7 r r r@ r r ú<module>rA s ðõ å ÷=4ò =4r
|
