Deleting Sheet from workbook - python

user_9580869 0
Viewed 27498

I want to delete a sheet from my Excel file and i am trying this code:


import openpyxl

workbook1 = openpyxl.load_workbook(input_file_folder + input_file_name)
print(workbook1.sheetnames)
Sheet1 = workbook1['Sheet1']
workbook1.remove(Sheet1)
workbook1.save(input_file_folder + input_file_name)
writer.save()

The sheet names are printing out to be: ['Sheet1', 'Candidate Campaign 0', 'Candidate Campaign 6', 'Candidate Campaign 7', 'Candidate Campaign 8', 'Valid Campaigns']

But somehow the "Sheet1' is not getting deleted anyhow.

I even tried:


n = workbook1.sheetnames
workbook1.remove(n[1])

but this doesnt work as well.

Can anyone please pinpoint what's wrong. As this command is working with other sheets but only Sheet1(the default one) is not getting deleted.

openpyxl python-3.x
2 Answers

del workbook1['Sheet1']

As suggested by @Charlie Clark

user_95808690

Save the file using workbook1.save() instead of writer.save().

from openpyxl import load_workbook

wb = load_workbook(file_workbook)
if 'Sheet1' in wb.sheetnames:
    wb.remove(wb['Sheet1'])
wb.save(file_workbook)
user_30677480
Related