问从xlsx python读取映像将无法在关闭的文件上执行I/O操作。

EN

import openpyxl
from openpyxl_image_loader import SheetImageLoader


filename = 'media/planilhas/tabela_de_simulador.xlsx'
workbook = openpyxl.load_workbook(filename)

logos = workbook['operadoras']
image_loader = SheetImageLoader(logos)

image_loader.get('B2')

ValueError                                Traceback (most recent call last)
Input In [108], in <cell line: 1>()
----> 1 image_loader.get('B2')

File ~/Documents/busqueplanodesaude/backend/venv/lib/python3.9/site-packages/openpyxl_image_loader/sheet_image_loader.py:32, in SheetImageLoader.get(self, cell)
     30     raise ValueError("Cell {} doesn't contain an image".format(cell))
     31 else:
---> 32     image = io.BytesIO(self._images[cell]())
     33     return Image.open(image)

File ~/Documents/busqueplanodesaude/backend/venv/lib/python3.9/site-packages/openpyxl/drawing/image.py:64, in Image._data(self)
     60 def _data(self):
     61     """
     62     Open image and write it to a buffer when saving the workbook
     63     """
---> 64     img = _import_image(self.ref)
     65     fp = None
     66     # don't convert these file formats

File ~/Documents/busqueplanodesaude/backend/venv/lib/python3.9/site-packages/openpyxl/drawing/image.py:33, in _import_image(img)
     30     raise ImportError('You must install Pillow to fetch image objects')
     32 if not isinstance(img, PILImage.Image):
---> 33     img = PILImage.open(img)
     35 return img

File ~/Documents/busqueplanodesaude/backend/venv/lib/python3.9/site-packages/PIL/Image.py:3096, in open(fp, mode, formats)
   3093     exclusive_fp = True
   3095 try:
-> 3096     fp.seek(0)
   3097 except (AttributeError, io.UnsupportedOperation):
   3098     fp = io.BytesIO(fp.read())

ValueError: I/O operation on closed file.