U o^ @s,ddlmZddlmZGdddeZdS))copy) Worksheetc@s8eZdZdZddZddZddZdd Zd d Zd S) WorksheetCopyz Copy the values, styles, dimensions, merged cells, margins, and print/page setup from one worksheet to another within the same workbook. cCs||_||_|dSN)sourcetarget_verify_resources)selfZsource_worksheetZtarget_worksheetr s/private/var/folders/sd/whlwsn6x1_qgglc0mjv25_695qk2gl/T/pip-install-4zq3fp6i/openpyxl/openpyxl/worksheet/copier.py__init__szWorksheetCopy.__init__cCsPt|jts t|jts td|j|jkr4td|jj|jjkrLtddS)NzCan only copy worksheetsz!Cannot copy a worksheet to itselfz7Cannot copy between worksheets from different workbooks) isinstancerrr TypeError ValueErrorparentr r r r r s   zWorksheetCopy._verify_resourcescCst||t|jj|j_t|jj|j_t|jj|j_t|jj|j_t|jj |j_ t|jj |j_ dSr) _copy_cells_copy_dimensionsrrZ sheet_formatrZsheet_propertiesZ merged_cellsZ page_marginsZ page_setupZ print_optionsrr r r copy_worksheet#szWorksheetCopy.copy_worksheetcCst|jjD]b\\}}}|jj||d}|j|_|j|_|jrJt|j |_ |j r\t|j |_ |j r t|j |_ q dS)N)columnrow) rZ_cellsitemsrcell_valueZ data_typeZ has_styler_styleZ hyperlinkZ _hyperlinkcomment)r rcolZ source_cellZ target_cellr r r r/s  zWorksheetCopy._copy_cellscCsPdD]F}t|j|}t|j|}|D] \}}t|||<|j||_q(qdS)N)Zrow_dimensionsZcolumn_dimensions)getattrrrrr worksheet)r attrsrcrkeyZdimr r r r@s    zWorksheetCopy._copy_dimensionsN) __name__ __module__ __qualname____doc__r r rrrr r r r r s   rN)rrrobjectrr r r r s