ActiveX VT_ERROR, xlsread and Bloomberg API

1 次查看（过去 30 天）

Matlab2010 2013-2-27

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

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by