如何在Python中集成Excel = RTD（）函数 [英] How to integrate Excel =RTD() function in python

问题描述

我正在使用来自专有应用程序的实时数据，该应用程序提供实时天气数据。我从数据中所知道的就是，它提供了一个导入到excel的链接：

I am using a real-time-data from a proprietary application which provides real time weather data. All I know know from the data is, it provides a link to import to excel as:

= RTD（ 4cast.wetter， city， parameter ）
此参数包括温度，湿度，风速，雨滴等。

=RTD("4cast.wetter",,"city","parameter") This parameter includes Temperature, Humidity, Wind speed, Rain fall etc.

我尝试阅读excel文档中提供的支持链接，但无法获取如果可以与Python一起使用。
http://support.microsoft.com/kb/289150

I tried reading the support link provided at excel documentation but couldn't get if it could be used with Python. http://support.microsoft.com/kb/289150

所以现在我的真正目的是直接在python中使用excel中RTD函数接收的数据。

So now my real purpose is to use this Data received by RTD function in excel directly in Python.

如RTD中所述文档，
调用组件对象模型（COM）自动化服务器以实时检索数据
是否有将COM服务器与Python集成的中间路线？

As said in RTD documentation, "call a Component Object Model (COM) Automation server to retrieve data in real time" Is there a midway to integrate this COM server with Python?

谢谢。

推荐答案

从您提供的链接看来，微软提供了VBA的包装器（但不提供Python的包装器）。

From the link which you have provided it seems that Microsoft has provided a wrapper for VBA(but not for Python).

我建议与数据提供者联系，以确定他是否提供Python API。这与Excel无关，但是它将允许您直接将数据接收到Python中。

I would suggest to check with the data provider if he offers an API to Python. This has nothing to do with Excel, but it would allow you to receive data directly into Python.

另一种选择是使用RDT在Excel中接收数据，并使用xlwings之类的东西。模块 http://xlwings.org/ 从Excel到Python获取数据。

Another option is to receive data in Excel using RDT and use something like xlwings module http://xlwings.org/ to get data from Excel to Python.

这篇关于如何在Python中集成Excel = RTD（）函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！