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');
采纳的回答
Image Analyst
2017-9-4
Before writetable(), add these 4 lines
recycle('on');
if exist(filename, 'file')
delete(filename);
end
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 ファイルの操作 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
