"Vfi 8ddlmZddlmZGddZdS))copy) Worksheetc0eZdZdZdZdZdZdZdZdS) WorksheetCopyz Copy the values, styles, dimensions, merged cells, margins, and print/page setup from one worksheet to another within the same workbook. cJ||_||_|dSN)sourcetarget_verify_resources)selfsource_worksheettarget_worksheets Hc:\PYTHON\DbComparer\venv\Lib\site-packages\openpyxl/worksheet/copier.py__init__zWorksheetCopy.__init__s(& &       ct|jts)t|jtst d|j|jurt d|jj|jjkrt ddS)NzCan only copy worksheetsz!Cannot copy a worksheet to itselfz7Cannot copy between worksheets from different workbooks) isinstancer rr TypeError ValueErrorparentr s rr zWorksheetCopy._verify_resourcess4; 22 8t{I66 8677 7 ;$+ % %@AA A ; !3 3 3VWW W 4 3rc||t|jj|j_t|jj|j_t|jj|j_t|jj|j_t|jj |j_ t|jj |j_ dSr ) _copy_cells_copy_dimensionsrr sheet_formatr sheet_properties merged_cells page_margins page_setup print_optionsrs rcopy_worksheetzWorksheetCopy.copy_worksheet#s  #' (@#A#A  '+DK,H'I'I $#' (@#A#A  #' (@#A#A  !%dk&%)+*<%=%= "$ E)-k.C)D)D &" @&*;+>&?&? # @ @rcdD]j}t|j|}t|j|}|D])\}}t |||<|j||_*kdS)N)row_dimensionscolumn_dimensions)getattrr r r'r worksheet)r attrsrcr keydims rrzWorksheetCopy._copy_dimensions@s}; 4 4D$+t,,CT[$//FIIKK 4 4S"3iis (, s %% 4 4 4rN) __name__ __module__ __qualname____doc__rr r"rrrrrr sr !!! X X X D D D@@@"44444rrN)rr7rrr@rrrAs] =4=4=4=4=4=4=4=4=4=4r