2

I'm trying to create a standalone executable with Python 3.6. Usually I used pyinstaller to do this, but by importing "openpyxl" a recursion error occurs. I tried several things, but I don't get it working. Is there anyone who can help me? This is my simple code:

from openpyxl import load_workbook
print("Hello World")

What I tried so far:

  • Trying to change the recursion limit like this, but getting the error "Cannot find existing PyQt5 plugin directories" (I'm not using Qt in my script)

  • Following this instruction: using cx_Freeze. Error: KeyError: 'TCL_LIBRARY'

  • Using py2exe like shown here, but getting the error File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\py2exe\mf3.py", line 417, in _scan_opcodes yield "store", (names[oparg],) IndexError: tuple index out of range

Now I run out of ideas what to do... edit: I cannot switch to python 3.5

So this is the error message of my first try to use pyinstaller like I did several times before, which would be my preferred way to solve this. I had to delete it partially as I may not enter as many characters as I needed to. After this error I tried the three steps shown above.

C:\Users\xxx\AppData\Roaming\Python\Python36\Scripts>pyinstaller.exe --onefile C:/users/xxx/desktop/testnew.py
110 INFO: PyInstaller: 3.4
110 INFO: Python: 3.6.4
110 INFO: Platform: Windows-10-10.0.17763-SP0
110 INFO: wrote C:\Users\xxx\AppData\Roaming\Python\Python36\Scripts\testnew.spec
110 INFO: UPX is not available.
126 INFO: Extending PYTHONPATH with paths
['C:\\users\\xxx\\desktop',
 'C:\\Users\\xxx\\AppData\\Roaming\\Python\\Python36\\Scripts']
126 INFO: checking Analysis
126 INFO: Building because C:\users\xxx\desktop\testnew.py changed
126 INFO: Initializing module dependency graph...
126 INFO: Initializing module graph hooks...
126 INFO: Analyzing base_library.zip ...
3430 INFO: running Analysis Analysis-00.toc
3446 INFO: Adding Microsoft.Windows.Common-Controls to dependent assemblies of final executable
  required by c:\program files\anaconda3\python.exe
3680 INFO: Caching module hooks...
3696 INFO: Analyzing C:\users\xxx\desktop\testnew.py
5523 INFO: Processing pre-find module path hook   distutils
6436 INFO: Processing pre-find module path hook   site
6436 INFO: site: retargeting to fake-dir 'C:\\Users\\xxx\\AppData\\Roaming\\Python\\Python36\\site-packages\\PyInstaller\\fake-modules'
7499 INFO: Processing pre-safe import module hook   setuptools.extern.six.moves
13325 INFO: Processing pre-safe import module hook   six.moves
22325 INFO: Processing pre-safe import module hook   urllib3.packages.six.moves
36970 INFO: Processing pre-safe import module hook   win32com
Traceback (most recent call last):
  File "c:\program files\anaconda3\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "c:\program files\anaconda3\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\Scripts\pyinstaller.exe\__main__.py", line 9, in <module>
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\__main__.py", line 111, in run
    run_build(pyi_config, spec_file, **vars(args))
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\__main__.py", line 63, in run_build
    PyInstaller.building.build_main.main(pyi_config, spec_file, **kwargs)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\building\build_main.py", line 838, in main
    build(specfile, kw.get('distpath'), kw.get('workpath'), kw.get('clean_build'))
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\building\build_main.py", line 784, in build
    exec(text, spec_namespace)
  File "<string>", line 17, in <module>
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\building\build_main.py", line 241, in __init__
    self.__postinit__()
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\building\datastruct.py", line 158, in __postinit__
    self.assemble()
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\building\build_main.py", line 443, in assemble
    priority_scripts.append(self.graph.run_script(script))
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\depend\analysis.py", line 201, in run_script
    self._top_script_node = super(PyiModuleGraph, self).run_script(pathname)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1348, in run_script
    self._scan_code(m, co, co_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2544, in _scan_code
    self._process_imports(module)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2743, in _process_imports
    target_module = self._safe_import_hook(*import_info, **kwargs)[0]
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2221, in _safe_import_hook
    target_attr_names=None, level=level, edge_attr=edge_attr)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1421, in import_hook
    source_package, target_module_partname, level)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1573, in _find_head_package
    target_module_headname, target_package_name, source_package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\depend\analysis.py", line 271, in _safe_import_module
    module_basename, module_name, parent_package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1990, in _safe_import_module
    module_name, file_handle, pathname, metadata)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2028, in _load_module
    m = self._load_package(fqname, pathname, packagepath)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2813, in _load_package
    self._load_module(fqname, fp, buf, stuff)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2082, in _load_module
    self._scan_code(m, co, co_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2544, in _scan_code
    self._process_imports(module)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2743, in _process_imports
    target_module = self._safe_import_hook(*import_info, **kwargs)[0]
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2221, in _safe_import_hook
    target_attr_names=None, level=level, edge_attr=edge_attr)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1422, in import_hook
    target_module = self._load_tail(target_package, target_module_partname)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1635, in _load_tail
    submodule = self._safe_import_module(head, mname, submodule)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\depend\analysis.py", line 271, in _safe_import_module
    module_basename, module_name, parent_package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1990, in _safe_import_module
    module_name, file_handle, pathname, metadata)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2028, in _load_module
    m = self._load_package(fqname, pathname, packagepath)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2813, in _load_package
    self._load_module(fqname, fp, buf, stuff)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2082, in _load_module
    self._scan_code(m, co, co_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2544, in _scan_code
    self._process_imports(module)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2743, in _process_imports
    target_module = self._safe_import_hook(*import_info, **kwargs)[0]
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2221, in _safe_import_hook
    target_attr_names=None, level=level, edge_attr=edge_attr)


..........



  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2028, in _load_module
    m = self._load_package(fqname, pathname, packagepath)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2813, in _load_package
    self._load_module(fqname, fp, buf, stuff)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2082, in _load_module
    self._scan_code(m, co, co_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2544, in _scan_code
    self._process_imports(module)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2743, in _process_imports
    target_module = self._safe_import_hook(*import_info, **kwargs)[0]
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2417, in _safe_import_hook
    edge_attr=edge_attr)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1438, in import_hook
    target_module, target_attr_names):
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1726, in _import_importable_package_submodules
    attr_name, submodule_name, package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\depend\analysis.py", line 271, in _safe_import_module
    module_basename, module_name, parent_package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1990, in _safe_import_module
    module_name, file_handle, pathname, metadata)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2082, in _load_module
    self._scan_code(m, co, co_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2544, in _scan_code
    self._process_imports(module)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2743, in _process_imports
    target_module = self._safe_import_hook(*import_info, **kwargs)[0]
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2417, in _safe_import_hook
    edge_attr=edge_attr)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1438, in import_hook
    target_module, target_attr_names):
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1726, in _import_importable_package_submodules
    attr_name, submodule_name, package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\depend\analysis.py", line 271, in _safe_import_module
    module_basename, module_name, parent_package)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 1990, in _safe_import_module
    module_name, file_handle, pathname, metadata)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2082, in _load_module
    self._scan_code(m, co, co_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2532, in _scan_code
    self._scan_ast(module, module_code_object_ast)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 2561, in _scan_ast
    visitor.visit(module_code_object_ast)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 965, in visit_FunctionDef
    self.generic_visit(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 960, in visit_If
    self.generic_visit(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 960, in visit_If
    self.generic_visit(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 960, in visit_If
    self.generic_visit(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "C:\Users\xxx\AppData\Roaming\Python\Python36\site-packages\PyInstaller\lib\modulegraph\modulegraph.py", line 960, in visit_If
    self.generic_visit(node)
  File "c:\program files\anaconda3\lib\ast.py", line 261, in generic_visit
    self.visit(item)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "c:\program files\anaconda3\lib\ast.py", line 263, in generic_visit
    self.visit(value)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "c:\program files\anaconda3\lib\ast.py", line 263, in generic_visit
    self.visit(value)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "c:\program files\anaconda3\lib\ast.py", line 263, in generic_visit
    self.visit(value)
  File "c:\program files\anaconda3\lib\ast.py", line 253, in visit
    return visitor(node)
  File "c:\program files\anaconda3\lib\ast.py", line 257, in generic_visit
    for field, value in iter_fields(node):
RecursionError: maximum recursion depth exceeded
Improve this question
3
  • Could you provide more informations about what your script does and which external libraries you are using? Commented Jun 6, 2019 at 8:20
  • ok, I'll edit it, one moment Commented Jun 6, 2019 at 8:38
  • I figured out now that the problem comes from the import of openpyxl, but don't have a solution... Commented Jun 6, 2019 at 9:58

1 Answer 1

Reset to default
1

Finally I made it:

  1. pip uninstall openpyxl
  2. pip install openpyxl==2.3.5
  3. pip install PyQt5
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.