在openpyxl模块中遇到权限不足的问题
代码块
from tempfile import NamedTemporaryFile
from openpyxl import Workbook
wb = Workbook()
with NamedTemporaryFile() as tmp:
print(tmp.name)
wb.save(tmp.name)
tmp.seek(0)
stream = tmp.read()
运行结果及报错内容
Traceback (most recent call last):
File "D:\scripts\office\openpyxl_tutorial2.py", line 8, in <module>
wb.save(tmp.name)
File "D:\Program Files (x86)\python310\lib\site-packages\openpyxl\workbook\workbook.py", line 407, in save
save_workbook(self, filename)
File "D:\Program Files (x86)\python310\lib\site-packages\openpyxl\writer\excel.py", line 291, in save_workbook
archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True)
File "D:\Program Files (x86)\python310\lib\zipfile.py", line 1249, in __init__
self.fp = io.open(file, filemode)
PermissionError: [Errno 13] Permission denied: 'C:\\Users\\13233\\AppData\\Local\\Temp\\tmp6mgdmc5d'
权限的问题还没有想到好的解决办法
解决好权限的问题