Read-Only in Excel

Question

Philosophaie 2013-9-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/87565-read-only-in-excel

When I execute the code below it prints out in Excel ok but it is in "Read-Only". How do I stop "Read-Only"?

exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open(['C:/MATLAB7/work/file.xls']);
exlSheet1 = exlFile.Sheets.Item('Sheet1');
mm=2
for t = 0:500:10000
    mm=mm+1
    vx1=6*t-800
    vy1=3*t-300
    vz1=2*t-100
    vr1=(vx1^2+vy1^2+vz1^2)^.5
        exlSheet1.Range(['B' num2str(mm)]).value = vx1;
        exlSheet1.Range(['C' num2str(mm)]).value = vy1;
        exlSheet1.Range(['D' num2str(mm)]).value = vz1;
        exlSheet1.Range(['E' num2str(mm)]).value = vr1;
end
        exl.visible = true;
exlWkbk.Close;
exl.Quit;

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

请先登录，再进行评论。

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

Answer 1

Titus Edelhofer 2013-9-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/87565-read-only-in-excel#answer_97135

在 MATLAB Online 中打开

Hi, I'm not sure what your question is. But in any case you will need to call

exlWkbk.Save

before you close it, since you modified it before. Second, if you get an error of "Read only", the natural question is: is your file read only (i.e., write protected)?

Titus