I want to overwrite my old xls file with the new xls file each time i generate a new data

Question

Steve 2011-11-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/22134-i-want-to-overwrite-my-old-xls-file-with-the-new-xls-file-each-time-i-generate-a-new-data

I am new to matlab and I am using "xlswrite" operation. At 1st, I am generating 150 data into a xls file. After the 1st testing, I am thinking to generate 2 data into the xls but only the 1st and 2nd data in the xls file being overwritten and data from 3rd until 150th of the 1st testing is still there. What can I do to make sure I only get the numbers of data that I want in the xls file?

My codes as below

clc
a=input('Enter Number of Cities need to travel: ');
b=2;
city= randi(100,[a,b])
xlswrite('Data.xls',city

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

请先登录，再进行评论。

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

Answer 1

LY Cao 2011-11-24

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/22134-i-want-to-overwrite-my-old-xls-file-with-the-new-xls-file-each-time-i-generate-a-new-data#answer_29138

在 MATLAB Online 中打开

    clc
a = input('Enter Number of Cities need to travel: ');
b = 2;
t = xlsread('Data.xls');
if ~isempty(t)
    xlswrite('Data.xls',zeros(size(t))*nan);
end
city = randi(100,[a,b]);
xlswrite('Data.xls',city);