Xlswrite catching an error (Error: Call was rejected by the callee)

Hello,

I am using xlswrite to import data(250,1) into an existed *.xlsm file; Several days ago, xlswrite worked normally, but now it keeps stopping after catching the following error:

"Warning: the following error was caught whilst using the onCleanup class destructor:" "Error: Call was rejected by the callee"

Any suggestions as to why this is happening and how to fix it would be greatly appreciated.

Thank you.

Lisa

[Patrick Mirek]

I got this error when I moved my App Designer functions to a different folder. When I went back in the original folder and ran those functions, the error was gone.

Answer 1

[Shashank Prasanna]

This seems to be an error on the Excel side. xlswrite relies on Excel to push data into an excel file and uses the COM interface to do so.

Searching for this error message on google returns several links to Excel failing with this error. Maybe one of those workarounds may be of help.

If not try a simple restart MATLAB and excel and try again.

[Lisa Wu]

1、Restart matlab and excel can not eliminate such error ; 2、There are few message about this error ; 3、if I import data into an newly created file ,such as *.xlsx ,it doesn't appear above error.

Thank you.

[Guido Travaglini]

Don't leave the Excel data file open when invoking it through Matlab in xlsread.