Excel sheet creation error
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Image Analyst
le 4 Sep 2017
Before writetable(), add these 4 lines
recycle('on');
if exist(filename, 'file')
delete(filename);
end
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur ファイルの操作 dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!