xlswrite() function is continuosly providing error ; Error using xlswrite (line 219), Invoke Error, Dispatch Exception: The parameter is incorrect.

I have installed Matlab R2011a and tried to use xlswrite() function, but I am getting error ; Error using xlswrite (line 219), Invoke Error, Dispatch Exception: The parameter is incorrect. I have installed other version of Matlab R2015a but error is still there? xlswrite('test.xsls', [12, 0,5]);

Please suggest the reason

[Jan]

Is the Excel file protected by a password?

[hanyue YU]

can you explain the problem in details?

Answer 1

[uriK]

I've battled this stupid error for too many hours, and only found one clue to what seemed to be the problem: Excel add-ins! Looking at the error message, I got the code 'MATLAB:COM:E0'. I looked in the add-ins section in Excel's options and what you know, FoxIt reader has installed an add-in that has to do with Excel's COM interface. I disabled it, restarted MATLAB and the error was gone!

This also solved the problem I had with xlsread(), which forced me to use the 'basic' parameter otherwise it wouldn't read any file.

[Sisi Di]

Many thanks, I've come up with the same problem, and your answer perfectly solve it.

[Andrei Denes]

Thank you! I just went through the same issue.

[ali]

worked like a charm!

[Maulik Shah]

Hi uriK, I am not sure which add-in to disable as I dont have any Foxlt reader as such. Could you please help me with it? thank you!

[Amir Tari]

I did what u said but still doesn't work and I have the same error

Answer 2

[Mus J]

Thanks. Your answer totally worked. I was extremely horrified by this error. I found some other solutions like changing windows installation from Click to Run to msi but none worked.

Answer 3

[Amir Tari]

I had this error and after all procedures I tried, my microsoft office's version was 2013 and I changed it to 2016 version and the error was gone!