import openpyxl
workbook = openpyxl.load_workbook('test.xlsx')
for i in workbook.worksheets:
    if i.title != 'Employee Info':
        workbook.remove_sheet(i)
Can't save a workbook after deleting sheets - openpyxl