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

Question

Mansi Sharma 2015-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252467-xlswrite-function-is-continuosly-providing-error-error-using-xlswrite-line-219-invoke-error

回答： Amir Tari 2019-8-13

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 个评论
显示无隐藏无

Jan 2015-11-3

Is the Excel file protected by a password?

hanyue YU 2017-1-4

can you explain the problem in details?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

uriK 2016-5-18

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252467-xlswrite-function-is-continuosly-providing-error-error-using-xlswrite-line-219-invoke-error#answer_222571

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 个评论
显示 3更早的评论隐藏 3更早的评论

Maulik Shah 2017-9-8

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 2019-8-12

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

请先登录，再进行评论。

Answer 2

Mus J 2016-11-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252467-xlswrite-function-is-continuosly-providing-error-error-using-xlswrite-line-219-invoke-error#answer_243335

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.