xlwings 进程总是无法关闭

xlwings 进程总是无法关闭。close quit kill 都用了还是不行。程序运行完毕,表格就被进程占用,不能再次打开,只能手动关闭进程et.exe。求高手解答,


import xlwings as wx
import xlwings

app = wx.App(visible=False, add_book=False)  # type: xlwings.main.App
app.display_alerts = False  # 关闭一些提示信息,可以加快运行速度。 默认为 True。
app.screen_updating = False
wb1 = app.books.open(r".\1.xlsx")  # type:xlwings.main.Book
wb2 = app.books.open(r".\3.xlsx")  # type:xlwings.main.Book
sht1 = wb1.sheets["月度计划单"]  # type: xlwings.main.Sheet
sht2 = wb2.sheets["月度计划单"]  # type: xlwings.main.Sheet
info1 = sht1.used_range  # type: xlwings.main.Range
for i in info1.rows:  # type: xlwings.main.Range
    if str(i[1].value).find("600") == -1:
        pass
    else:
        list = []
        for j in i.columns:  # type: xlwings.main.Range
            list.append(str(j.value))
        info2 = sht2.used_range  # type: xlwings.main.Range
        nows = info2.last_cell.row
        for k in info2.rows:
            print(k)
            # if  str(k[1].value) == str(list[1]):
            #     break
        else:
            sht2.range(nows + 1, 1).expand('right').value = list
            sht2.range(nows + 1, 2).api.NumberFormat = "0"
wb2.save(r".\3.xlsx")
wb1.close()
wb2.close()
app.kill()
app.kill()