xlwings icon indicating copy to clipboard operation
xlwings copied to clipboard

Successful RunPython call returns empty error message

Open lunacek opened this issue 2 years ago • 3 comments

OS (e.g. Windows 10 or macOS Sierra)

Windows 10

Versions of xlwings, Excel and Python

xlwings 0.15.1, Office 2010, Python 3.7

Describe your issue (incl. Traceback!)

I have dozens of xlwings scripts that work well and do what are they supposed to do, but after installing openai library all Runpython calls return empty error message ...

image

When I run the same code through mock caller, it returns no error in interpreter.

Your traceback here


#### Include a minimal code sample to reproduce the issue (and attach a sample workbook if required!)

```python
# Your code here
# any script called from inside Excel will do this

lunacek avatar Feb 07 '23 15:02 lunacek

I am pretty sure this has been solved in the latest version of xlwings, you're on a very old release.

fzumstein avatar Feb 07 '23 15:02 fzumstein

I just upgraded to the latest version (0.29.1) and used fresh quickstart_standalone.xlsm the behavior is the same ... it is most likely not an issue of xlwings, but some other recently updated library, though I would like to get some pointers on where to look for the culprit.

lunacek avatar Feb 07 '23 17:02 lunacek

This is what's probably happening: the shell call returns with an error code, but nothing is written to the log file:

https://github.com/xlwings/xlwings/blob/main/xlwings/addin/Main.bas#L275-L286

fzumstein avatar Feb 07 '23 20:02 fzumstein