Problem with xlsread (Matlab not responding)

Hi guys,

I'm facing a very weird issue. All of a sudden, the xlsread command is no longer working. Using debug mode, I've noticed that the program stays forever at the command line:

Excel = actxserver('excel.application');

I'm running Matlab 2015a 64 bits and I use Excel 2013.

Any ideas?

thanks

ps: it was working normally this morning and I don't remember doing any modification on my computer since then.

Answer 1

[Jan]

Have you tried to turn the computer off and on?

[Sergio]

Of course I did.

Is this some kind of "The IT Crowd" joke? :P

[Cedric]

No, but sometimes ghost Excel applications stay in the background (especially when a function that creates a COM server crashes in the middle), and make further operations that involve resources like Excel files stall.

So it happens all the time, even after a reboot..?

[Sergio]

Since then, yes. Rebooted several times, turned it off and on...it's a mystery!

[Cedric]

My guess is that you won't have a lot of answers, as it may be an issue with your system, or of MATLAB integration in your system. The only thing that I could recommend is to create a COM server using another language (e.g. Python) and to see if it works. If it does, then maybe reinstall MATLAB.

Answer 2

[Image Analyst]

Why are you calling xlsread() when you've opened your workbook with ActiveX? Don't. Do it one way or the other, but not both at the same time.