Don't require to set the PYTHONPATH when working with OneDrive

[RobertvanLoon]

Windows 10, xlwings 0.17.1, Office 365, Python 3.7

Until yesterday my xlwings was working perfectly fine. This morning when I opened up the same spreadsheet I worked on the night before I got this error message:

ModuleNotFoundError: No module named 'Options_Pricer_RvL'
  File "<frozen importlib._bootstrap>", line 965, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 983, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
    return _bootstrap._gcd_import(name[level:], package, level)
  File "C:\Users\rober\Anaconda3\lib\importlib\__init__.py", line 127, in import_module
    module = import_module(module_name)
  File "C:\Users\rober\Anaconda3\lib\site-packages\xlwings\udfs.py", line 228, in get_udf_module
    module = get_udf_module(module_name)
  File "C:\Users\rober\Anaconda3\lib\site-packages\xlwings\udfs.py", line 447, in import_udfs
    return ToVariant(getattr(obj, method)(*pargs, **kwargs))
  File "C:\Users\rober\Anaconda3\lib\site-packages\xlwings\server.py", line 194, in Call
    return func(*args)
  File "C:\Users\rober\Anaconda3\lib\site-packages\win32com\server\policy.py", line 586, in _invokeex_
    return S_OK, -1, self._invokeex_(dispid, lcid, wFl

I did not change anything to any settings. The same issue appears on my desktop and my laptop. I've tried different sheets, all have the same problem. I am 100% sure the spreadsheet has the same name, and is in the same location, as the corresponding .py file.

Any idea what is going on? Help is much appreciated!

Thanks.

[fzumstein]

Does a quickstart sample work?

[RobertvanLoon]

Strangely enough a new clean sheet starting with udfs from scratch does work. But any existing sheet does not. Also not the 4 xlwings examples.

[fzumstein]

Do you have a value for UDF Modules in your add-in or config?

[RobertvanLoon]

Do you mean xlwings_udfs module in my spreadsheet? Yes, see pic.

The problem is not just with UDFs. Also matplotlib plots don't work anymore.

[RobertvanLoon]

I did some more testing and even a brand new workbook and .py file (with same name and location) gives me the same error message now. I have not done any updates to my Windows or Office that I am aware of.

Are there other things I can do to help finding to find the source of this problem?

[fzumstein]

What I actually meant is to doulbe check your config in the Ribbon and/or config files: https://docs.xlwings.org/en/stable/addin.html

[RobertvanLoon]

I have not changed my configuration in the Ribbon since I start using xlwings. I double checked but all locations are correct. UDFs used to work without specifying the UDF modules in the Ribbon. I did try to specify it explicitly but that didn't help. This is my .xlwings\xlwings.conf file if that helps:

"C:\Users\rober\Anaconda3\python.exe",""
"C:\Users\rober\Anaconda3\python.exe",""
"INTERPRETER",""
"CONDA ENV","base"
"LOG FILE",""
"USE UDF SERVER","False"
"DEBUG UDFS","False"
"PYTHONPATH","C:\Users\rober\Anaconda3\python.exe"
"CONDA BASE","C:\Users\rober\Anaconda3"
"UDF MODULES",""

[RobertvanLoon]

Looks like I found the issue, it seems to have something to do with Onedrive. Since I've moved my files from Onedrive to my local C: drive, everything works fine again. After moving them back to Onedrive, same problems. This is quite annoying as I use Onedrive all the time to use files on both my laptop and desktop.

Any idea what I need to change to Onedrive to get this fixed?

[fzumstein]

Can you please check if you get the same behaviour with 0.18? You will need to upgrade both the add-in and the Python package.

[RobertvanLoon]

I've upgraded de add-in and tried to upgrade the package using pip. In Pycharm I still see 0.17.1 though instead 0.18. Also installing xlwings via Pycharm directly only gets me to 0.17.1. Got the below screen when using pip: 

…

------ Original Message ------ From: "Felix Zumstein" <notifications@github.com> To: "xlwings/xlwings" <xlwings@noreply.github.com> Cc: "RobertvanLoon" <robert@vanloon.training>; "Author" <author@noreply.github.com> Sent: 16/03/2020 22:00:15 Subject: Re: [xlwings/xlwings] Yesterday no problems, today ModuleNotFoundError (#1275)

Can you please check if you get the same behaviour with 0.18? You will need to upgrade both the add-in and the Python package. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1275 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALI3DUTOV2GRIHH5W6TX36DRH2HN7ANCNFSM4LHI5MAA>.

[fzumstein]

you are on anaconda so might have installed xlwings previously via conda? best would be to clean up first via pip uninstall xlwings and conda remove xlwings, then try again with conda install -c conda-forge xlwings.

[RobertvanLoon]

Ok that clean-up worked. Have 0.18 installed now. But the Onedrive issue is still there unfortunately. I'm trying out a couple different things to see if it works, but so far no luck.

…

------ Original Message ------ From: "Felix Zumstein" <notifications@github.com> To: "xlwings/xlwings" <xlwings@noreply.github.com> Cc: "RobertvanLoon" <robert@vanloon.training>; "Author" <author@noreply.github.com> Sent: 17/03/2020 15:07:05 Subject: Re: [xlwings/xlwings] Yesterday no problems, today ModuleNotFoundError (#1275)

you are on anaconda so might have installed xlwings previously via conda? best would be to clean up first via pip uninstall xlwings and conda remove xlwings, then try again with conda install -c conda-forge xlwings. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1275 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALI3DURMF3TNWAQGV6GJLY3RH57YTANCNFSM4LHI5MAA>.

[fzumstein]

One thing I noticed is that your config file looks a bit funny, i.e. wrong e.g. with the PYTHONPATH. Can you cut it down to the following:

"CONDA ENV","base"
"CONDA BASE","C:\Users\rober\Anaconda3"

and try again?

[RobertvanLoon]

Looks like we're getting closer. But when I run xlwings I get error messages from which it looks like I have to reinstall all my packages like nump, scipy, matplotlib etc. Previously I have always installed packages through Pycharm. And I still see those packages as installed in Pycharm.

…

------ Original Message ------ From: "Felix Zumstein" <notifications@github.com> To: "xlwings/xlwings" <xlwings@noreply.github.com> Cc: "RobertvanLoon" <robert@vanloon.training>; "Author" <author@noreply.github.com> Sent: 17/03/2020 15:50:47 Subject: Re: [xlwings/xlwings] Yesterday no problems, today ModuleNotFoundError (#1275)

One thing I noticed is that your config file looks a bit funny, i.e. wrong e.g. with the PYTHONPATH. Can you cut it down to the following: "CONDA ENV","base" "CONDA BASE","C:\Users\rober\Anaconda3" and try again? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1275 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALI3DUVEKM5QUMYKTUIMQDLRH6E4PANCNFSM4LHI5MAA>.

[fzumstein]

While you can install them with PyCharm, you will always install them into one of the conda environments. Are they installed in the base environment where you are pointing xlwings to?