python - 无法从 'save_virtual_workbook' 导入名称 'openpyxl.writer.excel'

Question

图书馆有更新吗？

之前它完美运行，今天我更新了它不再加载

我搜索了但找不到任何其他选项

Answer 1

看起来开发人员的新建议是使用临时文件: https://openpyxl.readthedocs.io/en/3.1/tutorial.html?highlight=save#saving-as-a-stream

更新:我最终不得不修改后使用它

from tempfile import NamedTemporaryFile
from openpyxl import Workbook

wb = Workbook()

with NamedTemporaryFile() as tmp:
    tmp.close() # with statement opened tmp, close it so wb.save can open it
    wb.save(tmp.name)
    with open(tmp.name, 'rb') as f:
        f.seek(0) # probably not needed anymore
        new_file_object = f.read()

因为 with 语句打开文件，然后 wb.save(需要一个 string filename)试图打开它，导致 Exception