使用xlwings在excel中用按钮运行python报错
PHPz
PHPz 2017-04-18 09:19:50
0
0
534

按照xlwings官方文档操作,网址如下
http://docs.xlwings.org/en/st...
注意这个文档中有文件命名错误

Sub HelloWorld()
    RunPython ("import hello; hello.world()")
End Sub

This calls the following code in mymodule.py:

# hello.py 
import numpy as np
import xlwings as xw

def world():
    wb = xw.Book.caller()
    wb.sheets[0].range('A1').value = 'Hello World!'

You can then attach HelloWorld to a button or run it directly in the VBA Editor by hitting F5.

然后我是用按钮绑定了宏,点击以后出现这个错误提示

求解答。

PHPz
PHPz

学习是最好的投资!

reply all(0)
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template