PermissionError [errno 13] when running openpyxl python script in Komodo
Question: 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 = wb.active
    ws1.title = "range names"
    
    for row in range(1, 40):
        ws1.append(range(600))
    
    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)
    wb.save(filename = dest_filename)
    

\-------Begin Error-----------

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

Thanks for the help.


Answer: 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.

