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!