fsociety fsociety - 1 month ago 15
Python Question

Add a new sheet to a existing workbook in python

I have browsed almost all the previous threads, but still cannot get this working.I am trying to add a new sheet to an existing workbook. My code works,but it keeps on adding a lot more (so many of them actually) sheets. I can't figure out the solution.Below is my code

from openpyxl import load_workbook
wb2 = load_workbook('template.xlsx')
from xlutils.copy import copy as xl_copy
wb = xl_copy(wb2)
wb.create_sheet('sid1')
wb.save('template.xlsx')

Answer

If you want to add a sheet to an existing spreadsheet, just go ahead and add the new sheet to the file instead of copying your load object and trying to add the new sheet to it.

from openpyxl import load_workbook
wb2 = load_workbook('template.xlsx')
wb2.create_sheet('sid1')
wb2.save('template.xlsx')
Comments