How to set Pycharm output path file by python

Question

I write the code below to excel file but It have error

"C:\Users\InsiskyLee\AppData\Local\Programs\Python\Python36\python.exe: can't open file 'Test': [Errno 2] No such file or directory"

How to fix it? How to save file by specific path?

from openpyxl import Workbook
import time


book = Workbook()
sheet = book.active

sheet['A1'] = 56
sheet['A2'] = 43

now = time.strftime("%x")
sheet['A3']=now

book.save("C:\\InsiskyLee\Desktop\TestWriteToExcel.xlsx")

ThunderHorn · Accepted Answer · 2018-06-24 12:12:22Z

2

You must put the path into a raw string because "\" is the escape character in python try

book.save(r"C:\InsiskyLee\Desktop\TestWriteToExcel.xlsx")

answered Jun 24, 2018 at 12:12

ThunderHorn

2,0452 gold badges24 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Insisky Lee Over a year ago

Still have same error : can't open file 'Test': [Errno 2] No such file or directory.

ThunderHorn Over a year ago

Show me how you defined the path to the file

Collectives™ on Stack Overflow

How to set Pycharm output path file by python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related