xlsread error: Invalid ConnectionPointContainer

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

[Friedrich]

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]

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});

The file is ..\toolbox\matlab\winfun\registerevent.m, line 148

Answer 1

[Geert]

Did you make sure that your current Matlab path is the same as the folder where 'Test.xlsx' is stored?

A save way of preventing this is issue is specifying the full path, for example:

>> [ndata, text, alldata] = xlsread('C:\Users\Fontys\Desktop\Test.xls')

Does this solve your problem?

[Fontys]

Yes, I made sure of that. If I specify the whole filename it prompts the same error.

Thanks anyway.