ActiveX VT_ERROR, xlsread and Bloomberg API

2013 2 27
0 个回答
7 次查看（30 天）

0 个投票

I am running win7, office 2007, Bloomberg professional and Matlab 2011a.
I have a value in an xlsx sheet equal to "=BDP('SPX Index, 'PX_LAST');
all this does is return a value to this cell, eg "10".
I call the xls sheet through xlsread. When I go to inspect that value I see the content of the cell is "ActiveX VT_ERROR" and not 10.
I don't wish to copy and paste "values" before calling xlsread.m as the process is automated.
How can I import the data into Matlab via the xls sheet? (of course one can use blp.m if not going via xls).
thanks

请先登录，再回答此问题。

回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

提问:

Matlab2010
Matlab2010
2013-2-27

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by