python - 如何在不保存的情况下使用 win32com 退出 Excel？

Question

当我执行 xl.Quit() 时，Excel 总是弹出一个提示，询问我是否要保存。如何告诉它我不想保存？

xl = Dispatch('Excel.Application')
xl.Workbooks.Open('New Workbook.xlsx')
# do some stuff

xl.Quit()

Answer 1

from win32com.client import Dispatch

# Start excel application
xl = Dispatch('Excel.Application')

# Open existing excel file
book = xl.Workbooks.Open('workbook.xlsx')

# Some arbitrary excel operations ...    

# Close excel application without saving file
book.Close(SaveChanges=False)
xl.Quit()