I cannot close Excel 2016 after executing a xlwing

2020-05-24 05:38发布

when I execute a an Xlwings function I can save and close the workbook. But I cannot close Excel 2016 anymore. Is this a known issue? How can I fix this?

标签: excel xlwings
1条回答
唯我独甜
2楼-- · 2020-05-24 05:53

Here is how I got it to work:

import xlwings as xw
wbPath = [WorkbookPath]
wb = xw.Book(wbPath) 
app = xw.apps.active    
wb.save(wbPath)
#wb.close()

app.quit()

Note that I commented out the line wb.close(). You can skip this step and instead set the app = active Excel instance, save the workbook, and then quit the app.

查看更多
登录 后发表回答