openpyxl error

RajeshPatnaik

Hello,

ArcGIS Pro version: 3.0.0

openpyxl version: 3.0.9

I am trying to create an excel and edit it.

import openpyxl
layer = r"F:\Learning\Area.shp"
desc = arcpy.Describe(layer)
path = desc.path
target = path + '/' + 'CA.xlsx'
wb = openpyxl.Workbook(target)
wb.save(target)
ws = wb.active
ws.title = 'MySheet'

It is working fine till this line of code. Then when I try to save it again, it throws an error.

wb.save(target)

Traceback (most recent call last):
File "<string>", line 1, in <module>
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\site-packages\openpyxl\workbook\workbook.py", line 407, in save
save_workbook(self, filename)
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\site-packages\openpyxl\writer\excel.py", line 293, in save_workbook
writer.save()
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\site-packages\openpyxl\writer\excel.py", line 275, in save
self.write_data()
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\site-packages\openpyxl\writer\excel.py", line 75, in write_data
self._write_worksheets()
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\site-packages\openpyxl\writer\excel.py", line 215, in _write_worksheets
self.write_worksheet(ws)
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\site-packages\openpyxl\writer\excel.py", line 203, in write_worksheet
self._archive.write(writer.out, ws.path[1:])
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\zipfile.py", line 1734, in write
zinfo = ZipInfo.from_file(filename, arcname,
File "C:\Users\user\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\lib\zipfile.py", line 501, in from_file
st = os.stat(filename)
FileNotFoundError: [WinError 2] The system cannot find the file specified: 'C:\\Users\\user\\AppData\\Local\\Temp\\ArcGISProTemp24588\\openpyxl.xhbljeyb'

Why am I getting this error when trying to save a second time??

RajeshPatnaik

Thanks @dabrooks for your reply

I tried by uninstalling 3.0 and reinstalling 2.9. The issue was not solved.

After lot of search, I came to know that once we save our created workbook, we can not write again to it. So, I did as follows and it works.

import openpyxl
layer = r"F:\Learning\Area.shp"
desc = arcpy.Describe(layer)
path = desc.path
target = path + '/' + 'CA.xlsx'
wb = openpyxl.Workbook()
ws = wb.active
ws.title = 'MySheet'
#write here whatever needed

#save at the end
wb.save(target)