CODEWITHSUNDEEP
pythonpyinstallerexeopenpyxlgeopandas
Francesco Chirico
Francesco Chirico

Reputation: 61

openpyxl not found in exe file made with pyinstaller

I wrote a Python code using a virtual evn with pip, and I built it with pyinstaller to use it as executable, and it works. Now I'm moving to conda environment to use also geopandas, fiona and gdal. I can run it without any errors, but if I build the code into the .exe, this error raised:

Traceback (most recent call last):
  File "main.py", line 5, in <module>
  File "PyInstaller\loader\pyimod03_importers.py", line 495, in exec_module
  File "openpyxl\__init__.py", line 6, in <module>
  File "PyInstaller\loader\pyimod03_importers.py", line 495, in exec_module
  File "openpyxl\workbook\__init__.py", line 4, in <module>
  File "PyInstaller\loader\pyimod03_importers.py", line 495, in exec_module
  File "openpyxl\workbook\workbook.py", line 9, in <module>
  File "PyInstaller\loader\pyimod03_importers.py", line 495, in exec_module
  File "openpyxl\worksheet\_write_only.py", line 13, in <module>
  File "openpyxl\worksheet\_writer.py", line 23, in init openpyxl.worksheet._writer
ModuleNotFoundError: No module named 'openpyxl.cell._writer'
[12248] Failed to execute script 'main' due to unhandled exception!

I tried also to reinstall openpyxl through conda, but nothing changed. The command line to build is:

pyinstaller --onefile main_new.spec main.py

and the spec file is:

# -*- mode: python ; coding: utf-8 -*-
block_cipher = None

a = Analysis(['main.py'],
             pathex=[],
             binaries=[],
             datas=[('./inputs/*.csv', 'inputs')],
             hiddenimports=[
             'openpyxl',
             'xlrd',
             'xlswriter'
             ],
             hookspath=[],
             hooksconfig={},
             runtime_hooks=[],
             excludes=[],
             win_no_prefer_redirects=False,
             win_private_assemblies=False,
             cipher=block_cipher,
             noarchive=False)
pyz = PYZ(a.pure, a.zipped_data,
         cipher=block_cipher)

exe = EXE(pyz,
          a.scripts,
          a.binaries,
          a.zipfiles,
          a.datas,
          [],
          name='DESAT',
          debug=False,
          bootloader_ignore_signals=False,
          strip=False,
          upx=True,
          upx_exclude=[],
          runtime_tmpdir=None,
          console=True,
          disable_windowed_traceback=False,
          target_arch=None,
          codesign_identity=None,
          entitlements_file=None )

How can I solve this issue?

Thank you!

Upvotes: 4

Views: 11505

Answers (5)

Nick_Jo
Nick_Jo

Reputation: 111

In case this helps anyone: try installing and running your script in Jupyter Notebooks or a new IDE.

After a few hours trying to get my program, (that was working in Spyder, the Python terminal, and that I had compiled with Pyinstaller), to run I had a similar error. Openpyxl module not found.

I tried everything:

  • new env
  • restart anaconda navigator
  • restart windows
  • import modules in the warning file in the script
  • use '--hidden-import ...'

I was thinking of trying different compiler. Last chance before giving up I decided to run it on Jupyter Notebooks. I installed notebooks into my new environment, copied the whole program into a cell, ran it and found out that lxml module not found. After conda install lxml ran, and I re-compiled with pyinstaller I had a different error! re-ran again with --hidden-import openpyxl.cell._writer and I can go to sleep happy. -pandas 2.2.2, -python 3.12.5, -openpyxl 3.15, -tk 8.6.14, -numpy 1.26.4 I think that Jupyter or Spyder added some library that I was missing previously.

Upvotes: 0

AlSunel
AlSunel

Reputation: 11

I had the same problem related to pyinstaller installed into the global scope while all of the libraries used in my project were installed into venv. So I installed new version of pyinstaller to my venv scope and the problem had been solved. Downgrading version of openpyxl didn't help me. After solving it I got another error about module 'pyexcel_io'. And I added it to hidden-imports:

hiddenimports=['pyexcel_io']

Upvotes: 0

Bob Yang
Bob Yang

Reputation: 163

Explicitly importing the module does the trick. It can be imported from the command line, or by modifying the .spec file to import.

Command line mode:

pyinstaller main.py --hidden-import openpyxl.cell._writer

Note: The module name does not need to be wrapped in quotes

Modify the .spec way:

a = Analysis(
...
    hiddenimports=['openpyxl.cell._writer'],
...
)

Upvotes: 8

Francesco Chirico
Francesco Chirico

Reputation: 61

The error is referring to 'openpyxl.cell._writer' that is inside openpyxl. in fact, pyinstaller was actually able to find openpyxl. I checked inside, and I found that in the pip environment i was using the 3.0.9 version, while in the conda one I was using the 3.0.10. Downgrading to 3.0.9, no --hidden-import or other needed, it is just working.

Upvotes: 2

flipSTAR
flipSTAR

Reputation: 613

I think it might help to collect all submodules of openpyxl when building your *.exe.

Refer to this or to the many answers on this platform regarding hook-files: https://pyinstaller.org/en/stable/hooks.html#PyInstaller.utils.hooks.collect_submodules

edit: In my case I use it this way:

hook-files in the directory of your *.py (you want to convert) contain the collect_submodules function (right side in the screenshot) and in the *.spec file the hookspath is defined to be the same as your *.py (left side of the screenshot) enter image description here

Upvotes: 0

Related Questions