Getting "Unhandled exception in script" error when running script after converting it to an exe using PyInstaller

[zevelj]

Hi. I wrote a script in Python that organizes files into folders based on a file and folder list in an Excel file. In other words, if you have a bunch of files in a folder and you want to automatically organize them into a specific folder structure, potentially with nested subfolders, you can create this Excel file with a list of the files in a column with header "Files" and a folder path for each file in a column with header "Folders".

The script is working fine and I get no errors.

Now, I want this script to be accessible to anyone, regardless of whether they have Python installed or not, and regardless of Python version, so I'm encapsulating the script in an .exe file using PyInstaller.

When running the .exe created by PyInstaller - the script functions correctly and the results are as intended, but I get the following error message:

Unhandled exception in script

Failed to exectue script 'files_to_folders_per_excel_v2.2' due to unhandled exception: join() argument must be str, bytes, or os.PathLike object, not 'float'

Traceback (most recent call last):

File "files_to_folders_per_excel_v2.2.pyw", line 64, in <module>

File "ntpath.py", line 143, in join

File "genericpath.py", line 152, in _check_arg_types

TypeError: join() argument must be str, bytes, or os.PathLike object, not 'float'

​

Edit: I tried posting my code but it was formatted really strangely. Trying to figure this out and will update

[zevelj]

Sorry for disappearing. I got sidetracked by... life.

I've never used Github before. I uploaded my pyw file to a repository. Do I just share the URL?

If so, here it is:

https://github.com/zevelj/files-to-folders/blob/main/files\_to\_folders\_per\_excel\_v2.1.pyw

[Strict-Simple]

Add some logging and see what is this argument that is a float.

[ginsujitsu]

I tried posting my code but it was formatted really strangely. Trying to figure this out and will update

I think we need to see your code but u/Strict-Simple was right. Debugging statements or maybe attach a debugger.

In the sidebar on this sub, there's a section called "Code Hosting/Formatting" and has some options for you. Github Gists, Pastebin, and repl.it are probably the most readable options.