Changing file location

[azizrasul]

How do I amend the following code so that "filename.xlsx" is created in say "D:\SomeFolder\" and not in the default project folder.

import xlsxwriter
workbook  = xlsxwriter.Workbook('filename.xlsx')
worksheet = workbook.add_worksheet()
worksheet.write(0, 0, 'Salaams')
workbook.close()

[Yoriz]

Change 'filename.xlsx' to 'D:/SomeFolder/filename.xlsx'

[azizrasul]

OK, that worked. Just a knock-on question. What if I want to save the file in the root D drive? I tried D:/filename.xlsx which gave an error?

[bowlofred]

OK, that worked. Just a knock-on question. What if I want to save the file in the root D drive? I tried D:/filename.xlsx which gave an error?

What was the error?

[azizrasul]

"D:\Power BI & Python\venv\Scripts\python.exe" "D:/Power BI & Python/Test.py" 
Traceback (most recent call last):
  File "D:\Power BI & Python\venv\lib\site-packages\xlsxwriter\workbook.py", line 324, in close
    self._store_workbook()
  File "D:\Power BI & Python\venv\lib\site-packages\xlsxwriter\workbook.py", line 659, in _store_workbook
    raise e
  File "D:\Power BI & Python\venv\lib\site-packages\xlsxwriter\workbook.py", line 656, in _store_workbook
    xlsx_file = ZipFile(self.filename, "w", compression=ZIP_DEFLATED,
  File "C:\Users\Aziz\AppData\Local\Programs\Python\Python310\lib\zipfile.py", line 1249, in __init__
    self.fp = io.open(file, filemode)
PermissionError: [Errno 13] Permission denied: 'D:/filename.xlsx'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:\Power BI & Python\Test.py", line 5, in <module>
    workbook.close()
  File "D:\Power BI & Python\venv\lib\site-packages\xlsxwriter\workbook.py", line 326, in close
    raise FileCreateError(e)
xlsxwriter.exceptions.FileCreateError: [Errno 13] Permission denied: 'D:/filename.xlsx'

Process finished with exit code 1

[bowlofred]

You're getting a permission denied. Looks like you don't have permission to save files directly into D:. But that's outside the scope of your program. You might have to look at filesystem permissions or ACLs. Can you save a file from notepad there either?

[azizrasul]

I tried to copy a text file and it came up with a dialog box with 3 buttons i.e. Continue, Skip and Cancel. The title of the dialog box was Destination Folder Accessed Denied. When I press Skip it copies the file over no problem. Similar thing happens when I then try to delete the file.