Error using xlswrite (line 224)

Question

Yusuf Demirkaya 2021-6-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/858310-error-using-xlswrite-line-224

评论： Image Analyst 2021-6-17

I always get this error in different iteration values, sometimes in 43rd iteration, sometimes in 1251, but I can't figure out why.

Error using xlswrite (line 224)
Invoke Error, Dispatch Exception: 
Source: Microsoft Excel
Description: Office has detected a problem with this file. To help protect your computer this file cannot be opened.
Help File: xlmain11.chm
Help Context ID: 0
Error in RelaySimulationWithChangingPower (line 66)
    xlswrite('RelayDataTMS1',FLC1,1,['A' num2str(x)]);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2021-6-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/858310-error-using-xlswrite-line-224#answer_726640

If you're calling xlswrite 1251 times, you're not doing it right -- that will take forever. It's better to use ActiveX. See attached demos.

It could be it's not done closing it from the prior operation. Or else you manually went to it and started doing something in Excel and it got confused. Or maybe there is something wrong with your x value or FLC1 array.

2 个评论
显示无隐藏无

Yusuf Demirkaya 2021-6-17

在 MATLAB Online 中打开

Its my code block. Im working with simulink and m file. I want to make a xls file because then i will work on python for machine learning. And thats the xls file.

for ii= 1:2000       %% 10 iterations. 10 times power increased.
    tic;
    W=W+300;
    L1=L1+100;
    L2=L2+100;
    L3=L3+100;
    
    x=x+1;
    y=y+1;
    z=z+1;
    set_param('UsingMATLABFunction/Source', 'Pref','W');
    sim('UsingMATLABFunction.slx');
    save_system('UsingMATLABFunction.slx');
    
    xlswrite('RelayDataTMS1',FLC1,1,['A' num2str(x)]);
    xlswrite('RelayDataTMS1',FltC1,1,['B' num2str(x)]);
    xlswrite('RelayDataTMS1',OpTime1,1,['C' num2str(x)]);
    xlswrite('RelayDataTMS1',TMS1,1,['D' num2str(x)]);
    xlswrite('RelayDataTime1',FLC1,1,['A' num2str(x)]);
    xlswrite('RelayDataTime1',FltC1,1,['B' num2str(x)]);
    xlswrite('RelayDataTime1',TMS1,1,['C' num2str(x)]);
    xlswrite('RelayDataTime1',OpTime1,1,['D' num2str(x)]);