RunFrozenPython in xlwings complains on Workbook.caller() in Python

Question

I have a script in Python copying values from one spreadsheet to another. It runs well with RunPython When I try using RunFrozenPython it is giving this exception

xlwings thinks the caller is not excel, what can I do so it thinks the caller is Excel? just how RunPython does successfully.

Before I get the exception , I do get a warning , here is the snapshot. The script waits until I click OK and then errors out as shown above.

Here is the warning message, the location shown does not exist on my machine -

Try to upgrade both, the xlwings VBA module and the Python package to 0.4.0 and see if that helps... — Felix Zumstein, Sep 15 '15 at 20:44
I am using Excel-VBA to call a Python script which references the calling workbook using xlwings.Workbook.caller() method, which is erroring out, hence Excel-VBA / VBA — Nick, Sep 15 '15 at 21:04
I just upgraded to 0.4.0 and included the the bas file in my vba script, getting same error. Using Python 2.7.9. Your help is much appreciated Felix. — Nick, Sep 15 '15 at 21:21
The warning is from PyInstaller: http://stackoverflow.com/q/19055089/918626 — Felix Zumstein, Sep 16 '15 at 12:13

score 0 · Answer 1 · answered Sep 16 '15 at 01:02

0

I got the error resolved by using wb = Workbook("path to file")

instead of using wb = Workbook.caller()

This way the excel is not referenced by the caller but by its absolute path.

I could still use help resolving the warning :)

answered Sep 16 '15 at 01:02

Nick

31
11

That's not what you should be doing as this will break as soon as you move your spreadsheet or rename it. Posting a minimal code sample that will reproduce the error will help. I have never looked at freezing with PyInstaller though, only with cx_Freeze, so maybe that's part of the issue. – Felix Zumstein Sep 16 '15 at 12:03

RunFrozenPython in xlwings complains on Workbook.caller() in Python

1 Answers1