New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

In-Excel SQL addin: no module named xlwings.ext #695

Closed
ayemjay opened this Issue Jul 4, 2017 · 1 comment

Comments

Projects
None yet
2 participants
@ayemjay

ayemjay commented Jul 4, 2017

Hello,
Using Excel 2016 and xlwings v0.11, I am trying the new In-Excel SQL addin.
Every other xlwings feature works without issue.
But I have put a simple table and query together, and am encountering the following error:

ImportError: No module named 'xlwings.ext' File "<frozen importlib._bootstrap>", line 2224, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 2237, in _find_and_load File "<frozen importlib._bootstrap>", line 2254, in _gcd_import return _bootstrap._gcd_import(name[level:], package, level) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\importlib\__init__.py", line 109, in import_module module = import_module(module_name) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\site-packages\xlwings\udfs.py", line 208, in get_udf_module module = get_udf_module(module_name) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\site-packages\xlwings\udfs.py", line 221, in call_udf res = call_udf(script, fname, args, this_workbook, FromVariant(caller)) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\site-packages\xlwings\server.py", line 190, in CallUDF return func(*args) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\site-packages\win32com\server\policy.py", line 586, in _invokeex_ return S_OK, -1, self._invokeex_(dispid, lcid, wFlags, args, None, None) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\site-packages\win32com\server\policy.py", line 283, in _invoke_ return self._invoke_(dispid, lcid, wFlags, args) File "C:\Apps\WinPython-64bit-3.4.4.5Qt5\python-3.4.4.amd64\lib\site-packages\win32com\server\policy.py", line 278, in _Invoke_

image

@ayemjay

This comment has been minimized.

ayemjay commented Jul 4, 2017

Solved: the xlwings package from pip does not include the ext folder.
Installing from the Github release zip resolves the issue with all files present.

@fzumstein fzumstein added the bug label Jul 4, 2017

@fzumstein fzumstein added this to the v0.11.1 milestone Jul 4, 2017

@fzumstein fzumstein closed this in c0acf14 Jul 4, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment