xlswrite() function is continuosly providing error ; Error using xlswrite (line 219), Invoke Error, Dispatch Exception: The parameter is incorrect.
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
uriK
il 18 Mag 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 Commenti
Maulik Shah
il 8 Set 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!
Più risposte (2)
Mus J
il 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 Commenti
Amir Tari
il 13 Ago 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 Commenti
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!