xlsread error: Invalid ConnectionPointContainer

Question

Fontys 2013-8-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/85998-xlsread-error-invalid-connectionpointcontainer

在 MATLAB Online 中打开

Hi, I want to import some data from Excel to Matlab. I use xlsread:

[ndata, text, alldata] = xlsread('Test.xlsx')

(as suggested on the Mathworks website: http://www.mathworks.de/de/help/matlab/ref/xlsread.html

The Excel file contains a 3x3 table: [1,2,3;4,5,6;7,8,9]

The error I encounter is:

>> [ndata, text, alldata] = xlsread('Test.xls')
Error using xlsread (line 247)
Error registering event(s), Invalid ConnectionPointContainer

I use WinXP, Matlab R2012b and Excel 2007. (the same error occurs when I use an .xlsx file)

Can anyone help me?

Thanks

2 个评论
显示无隐藏无

Friedrich 2013-8-30

在 MATLAB Online 中打开

Can you run:

dbstop if caught error

before running xlsread. You should stop in the line which raises error. Which file and line is it?

Fontys 2013-9-2

在 MATLAB Online 中打开

There you go:

dbstop if caught error
[ndata, text, alldata] = xlsread('Test.xls')
Caught-error breakpoint was hit in registerevent>addevent at line 148. The error was:
Error registering event(s), Invalid ConnectionPointContainer
148 list(m+1) = handle.listener(h, eventname, {@comeventcallback, eventhandler});
148 list(m+1) = handle.listener(h, eventname, {@comeventcallback, eventhandler});