xlwings Calling python from VBA

Question

这是我尝试从Excel VBA中调用python脚本后收到的错误[http://docs.xlwings.org/quickstart.html]

Traceback (most recent call last):
  File "<string>", line 1, in <module>
ImportError: No module named mymodule
Press Ctrl+C to copy this message to the clipboard.

我在哪里保存module.py文件，其中包含：

import numpy as np
from xlwings import Workbook, Range
def rand_numbers():
    """ produces standard normally distributed random numbers with shape (n,n)"""
    wb = Workbook.caller()  # Creates a reference to the calling Excel file
    n = Range('Sheet1', 'B1').value  # Write desired dimensions into Cell B1
    rand_num = np.random.randn(n, n)
    Range('Sheet1', 'C3').value = rand_num

我已经将xlwings.bas作为一个模块导入到Visual Basic编辑器中，我在anaconda 2.1.0 上有python 2.7.8

$ which python
/c/ana/python
$ pip show xlwings
---
Name: xlwings
Version: 0.2.2
Location: c:analibsite-packages
Requires:

我假设xlwings.bas文件链接到我的pythonpath，但子过程如何知道如何调用module.py文件和/或子过程如何了解module.py的位置？

Sub RandomNumbers()
RunPython ("import mymodule; mymodule.rand_numbers()")
End Sub

Answer 1

默认情况下，xlwings VBA模块希望Python文件与Excel文件位于同一目录中。这是可以在展开VBA模块中更改的PYTHONPATH设置。