{"id":9,"date":"2026-01-22T11:40:54","date_gmt":"2026-01-22T03:40:54","guid":{"rendered":"https:\/\/openpyxl.com\/blog\/?p=9"},"modified":"2026-01-16T05:47:07","modified_gmt":"2026-01-16T05:47:07","slug":"how-to-copy-and-move-worksheets-using-openpyxl","status":"publish","type":"post","link":"https:\/\/openpyxl.com\/blog\/how-to-copy-and-move-worksheets-using-openpyxl.html","title":{"rendered":"How To Copy and Move Worksheets Using OpenPyXL?"},"content":{"rendered":"
Method<\/h2>\n
To copy a worksheet, use the `copy_worksheet` method:<\/p>\n
>>> copy_sheet=wb.copy_worksheet(ws)<\/p>\n
To move a worksheet (cut and paste), use the `move_sheet` method:<\/p>\n
>>> wb.move_sheet(ws, offset=1)<\/p>\n
The `offset` parameter specifies the number of positions to move the worksheet. If the value is greater than 0, the source sheet moves to the right by the specified number; if it\u2019s less than 0, it moves to the left.<\/p>\n
Sample Code<\/h2>\n\n\n
#Copying and Moving Worksheets\n\n#Import load_workbook function\nfrom openpyxl import Workbook\n\n#Create a new workbook\nwb=Workbook()\n#Get the active worksheet\nws=wb.active\n\n#Copy worksheets\ncopy_sheet1=wb.copy_worksheet(ws)\ncopy_sheet2=wb.copy_worksheet(ws)\n#Specify the title of the first copied worksheet\ncopy_sheet1.title='NewSheet'\n\n#Move worksheets\n#If the offset value n > 0, move n columns to the right;\n#n < 0, move n columns to the left\nwb.move_sheet(ws, offset=1)\n\nwb.save('test.xlsx')\nwb.close()<\/code><\/pre>\n\n\n\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
![\"\"](\"https:\/\/openpyxl.com\/blog\/wp-content\/uploads\/2026\/01\/3.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"