xlswrite() function is continuosly providing error ; Error using xlswrite (line 219), Invoke Error, Dispatch Exception: The parameter is incorrect.
6 views (last 30 days)
Show older comments
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
2 Comments
Accepted Answer
uriK
on 18 May 2016
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.
5 Comments
Maulik Shah
on 8 Sep 2017
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!
More Answers (2)
Mus J
on 15 Nov 2016
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.
0 Comments
Amir Tari
on 13 Aug 2019
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!
0 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!