我想隐式关闭有关类实例销毁的工作簿。 xlsxwriter.workbook.py 方法说要显式执行,然后它就可以工作。 但是在每个 Excel 文件创建脚本的末尾,我必须添加额外的行来关闭工作簿。有没有办法让它自动关闭?
import pandas as pd
import xlsxwriter
class ExcelFile():
def __init__(self, file_name):
self.writer = pd.ExcelWriter(file_name, engine='xlsxwriter')
self.workbook = self.writer.book
def __del__(self):
self.workbook.close()
print('del')
脚本:
e = ExcelFile('test.xlsx')
# e.workbook.close() <--This works but I don't want this line
请您参考如下方法:
您无法控制何时调用 __del__ 方法。 SO上已经有很多关于__del__的信息,你可以搜索它(例如https://stackoverflow.com/a/1481512/1453822)。
相反,我会使用上下文管理器:
class ExcelFile():
def __init__(self, file_name):
self.writer = pd.ExcelWriter(file_name, engine='xlsxwriter')
self.workbook = self.writer.book
def __enter__(self):
return self
def __exit__(self, exc_type, exc_val, exc_tb):
print('exit')
self.workbook.close()
with ExcelFile('test.xlsx') as e:
# do whatever with e
pass
输出将是:
'exit'
__exit__ promise 在您退出 with ExcelFile(..) block 时调用,即使出现异常也是如此:
with ExcelFile('test.xlsx') as e:
1/0
输出
Traceback (most recent call last):
File "main.py", line 57, in <module>
1/0
ZeroDivisionError: division by zero
exit
