|
cpu比较垃圾,而我又要在一个for循环内使用to_excel函数,这样容易造成Excel还没关掉,下一次for循环时又要使用excel们就会造成权限不足data.to_excel('test.xlsx',sheet_name='Sheet1',index=True,header=True) File "C:\Python\lib\site-packages\pandas\core\frame.py", line 1766, in to_excel
engine=engine)
File "C:\Python\lib\site-packages\pandas\io\formats\excel.py", line 654, in write
writer.save()
File "C:\Python\lib\site-packages\pandas\io\excel.py", line 1018, in save
return self.book.save(self.path)
File "C:\Python\lib\site-packages\openpyxl\workbook\workbook.py", line 391, in save
save_workbook(self, filename)
File "C:\Python\lib\site-packages\openpyxl\writer\excel.py", line 282, in save_workbook
archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True)
File "C:\Python\lib\zipfile.py", line 1090, in __init__
self.fp = io.open(file, filemode)
PermissionError: [Errno 13] Permission denied: 'test.xlsx'
程序能不能过,全看cpu够不够给力。我的想法是,在报错时,我就进入处理机制,强制将这个Excel先关了
|
|