Excel sheet creation error
1 次查看(过去 30 天)
显示 更早的评论
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');
0 个评论
采纳的回答
Image Analyst
2017-9-4
Before writetable(), add these 4 lines
recycle('on');
if exist(filename, 'file')
delete(filename);
end
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!