Getting error from xlsread

Hello,

I am trying to run a code which used to work perfectly using previous versions of Matlab. Now after upgrading to version 2015b I receive this error at line 251 of xlsread.m

Anybody knows anyway to fix this?

thank you.

[ravi]

I was encountering the same problem since long. I tried saving the excel file in 97-2003 format. And then xlsread worked well :-)

[Kashif Mehmood]

i tried this but still have problem

Answer 1

[xianjie Zhou]

What error message you got? I have the same problem, it saids: Error: The server threw an exception. But I run for second time it goes. I believe there are some solutions for that: http://www.mathworks.com/matlabcentral/answers/92603-why-does-xlswrite-fail-with-error-the-server-threw-an-exception-in-matlab-7-7-r2008b

[Armin Sadeghian]

When I check xlsread.m at line 251 I see the same error "threw exception".I reinstalled Matlab, but it did not solve my problem.

Answer 2

[XM Liu]

1- open the excel> file, >option, >add in, manage then select COM ADD IN, and clear everything (unchecked). everything should be cleared (unchecked). 2- restart the PC, and open the matlab. 3- perform xlsread command.

PS. For those people who use foxit pdf reader, it is potential to face this problem, so follow mentioned order.

[Henrik Persson]

Thank you XM Liu :) I had this issue and I was using foxit excel plugin. Disabling it and restarting solved the issue.

[Antoine Mailhot]

Thanks a lot! It solved my problem. It was actually the Foxit Reader COM ADD IN.

[An]

Also worked for me. Such a weird bug with Foxit... Thanks XM Liu!

[Atsushi]

Thanks Liu. It also worked for me with R2018a and Excel 2016.

Answer 3

[vcmorini]

Maybe it helps:

https://www.mathworks.com/matlabcentral/answers/92603-why-does-xlswrite-fail-with-error-the-server-threw-an-exception-in-matlab-7-7-r2008b

Answer 4

[Seth Wright]

Saving it as a csv file fixed it