Good job! Suppose you need several very similar worksheets in your workbook. Instead of making each one from scratch, you can copy an existing worksheet:
ws = wb.active wb_copy = wb.copy_worksheet(ws)
The new sheet will appear in your workbook under the name of the worksheet you copied and the word "Copy". If we had a "Calendar" worksheet and we copied it, the new sheet's name would be "Calendar Copy". However, you need to remember that:
openpyxl, it is not possible to copy elements like charts or images.To be safe, use copy_worksheet to copy cell data you want to preserve.
Copy the "Entertainment" worksheet and change the name of the copy to "Eating outside". Save the modified workbook in the file budget.xlsx.
To select a particular worksheet, use wb["name of worksheet"].
Use the title property to change the copied worksheet's name.
