How to choose file path in python script when using pyinstaller?

Question

I have a python script that takes data from an excel file (database.xlsx). I want to freeze the script (ecobel.py) using pyinstaller.

I'd like to know if in the python script I should use the current path where the database file is or if I should reference where I'm putting it in the executable path. I'm currently just calling the path where I'd normally put the database file on my laptop.

In addition, after entering the right path, I'm currently typing this in the comand prompt:

--onefile --add-data database.xlsx;. ecobel.py

which returns "No such file or directory: 'database.xlsx'" when launching the formed executable file.

Hi, I had seen the post thanks, but even after reading it it's still quite obscure how I should do it. His code isn't commented enough for me — Tommy95
– Tommy95, Commented Aug 30, 2019 at 15:01
Thanks, solved the problem thanks to this page: stackoverflow.com/questions/53587322/… Will update my post with solution — Tommy95
– Tommy95, Commented Aug 30, 2019 at 16:32
It is better to add the answer as Answer, so can help others with a similar problem. — Masoud Rahimi
– Masoud Rahimi, Commented Aug 30, 2019 at 16:40

Tommy95 · Accepted Answer · 2019-08-30 16:43:17Z

1

I Solved it thanks to this page: How do I include files with pyinstaller?

I put the database.xlsx in a file called database at the same directory level as where ecobel.py is.

I call database.xlsx this way in my ecobel.py script:

import sys
if getattr(sys, 'frozen', False):
    database = xlrd.open_workbook(os.path.join(sys._MEIPASS,'database/database.xlsx'))
else:
    database = xlrd.open_workbook('database/database.xlsx')

Then I type this in the command prompt:

--clean -y -n "ecobel" --add-data="database\database.xlsx;database" ecobel.py

"ecobel" will put the .exe file in a folder called ecobel. Don't know what -y and -n stand for, nor what --clean does, if someone can help.

answered Aug 30, 2019 at 16:43

Tommy95

1214 bronze badges

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

Collectives™ on Stack Overflow

How to choose file path in python script when using pyinstaller?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related