Flynnpc Flynnpc - 5 months ago 83
Python Question

PermissionError [errno 13] when running openpyxl python script in Komodo

I am having trouble using openpyxl scripts in Komodo edit 9 and python 3.4 on Windows 7. I copied some openpyxl code to learn, but it won't execute from Komodo. I receive a permission error 13. I checked my path and python34 is present. The same script will run when I use IDLE or Command Prompt. My Komodo command is currently:
%(python3) -u %F
Any ideas on what may be causing this issue? The code and error are included below

from openpyxl import Workbook
from openpyxl.compat import range
from openpyxl.cell import get_column_letter

wb = Workbook()

dest_filename = 'empty_book.xlsx'

ws1 =
ws1.title = "range names"

for row in range(1, 40):

ws2 = wb.create_sheet(title="Pi")

ws2['F5'] = 3.14

ws3 = wb.create_sheet(title="Data")
for row in range(10, 20):
for col in range(27, 54):
_ = ws3.cell(column=col, row=row, value="%s" % get_column_letter(col))
print(ws3['AA10'].value) = dest_filename)

-------Begin Error-----------

Traceback (most recent call last):
File "C:\Users\PF15043\Desktop\Scripts\Ggizmo\", line 26, in <module> = dest_filename)
File "C:\Python34\lib\site-packages\openpyxl-2.3.0b1-py3.4.egg\openpyxl\workbook\", line 254, in save
save_workbook(self, filename)
File "C:\Python34\lib\site-packages\openpyxl-2.3.0b1-py3.4.egg\openpyxl\writer\", line 195, in save_workbook, as_template=as_template)
File "C:\Python34\lib\site-packages\openpyxl-2.3.0b1-py3.4.egg\openpyxl\writer\", line 177, in save
archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True)
File "C:\Python34\lib\", line 923, in __init__
self.fp =, modeDict[mode])
PermissionError: [Errno 13] Permission denied: 'empty_book.xlsx'

Answer Source

This is simply an error from the operating system telling you that you don't have permissions to create a file where you're trying to. You should specify the full path of the file you're trying to create.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download