Excel sheet creation error

An Excel workbook can be created by writetable() command. When I overwrite with the same name Excel file but with different length data, the old data in the excel sheet still remains.

In an example below, after creating Excel sheet with len=100, I overwrite data made by len=10;

However, row 12 to row 101 data in the sheet remain the same as before. This R12 to R101 data should be deleted. I want to solve this issue.

Example

% ExcelWrite.m
len = 100; % 10;  << change length;
fr = (1:len)';
ga =zeros(len,1);
ph = zeros(len,1);
for i=1:len
    ga(i) = i+3.4;
    ph(i)= i*2+80-50.6*2;
end
%%Excel sheet write
T = table( fr, ga, ph,'VariableNames',{'Fre','gain','ph'});
filename = strcat('data','1','.xls');
writetable(T,filename,'sheet',1,'Range','A1');

Answer 1

[Image Analyst]

Before writetable(), add these 4 lines

recycle('on');
if exist(filename, 'file')
    delete(filename);
end

[Isao Okada]

I got a good result of which I desired by your answer. Thank you so much.