你可以尝试使用openpyxl库，如this主题中所建议的：

from openpyxl import load_workbook

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

正如前面的用户所说，最好使用openpyxl库。现在你只需要打开所有的excel文件，这是用glob库完成的。

import openpyxl
import glob
#select all excel archives
xlsx_files = glob.glob('*.xlsx')
#read individual excel archive(workbook)
for read in xlsx_files:
    wb = openpyxl.load_workbook(read)
    #example sheet name Prove
    if 'Prove' in wb.sheetnames:
        wb.remove(wb['Prove'])
    #Save workbook
    wb.save(read)