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)
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')