Write data to new excel file
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Suppose if I have an excel file saved like below: xlswrite('file1.xls',[1 2 3 4 5 6]);
The Excel file will contain data as [1 2 3 4 5 6] Later when I do: xlswrite('file1.xls',[9 8 10]);
The Excel file will contain data as [9 8 10 4 5 6] instead of just [9 8 10];
How to specify that clear previous content and write in fresh..?
0 Kommentare
Antworten (1)
KSSV
am 15 Dez. 2016
You can check whether the file exists...and then delete the file and use xlswrite.
clc; clear all ;
xlswrite('file1.xls',[1 2 3 4 5 6]);
if exist('file1.xls','file')
delete('file1.xls')
disp('file deleted')
end
xlswrite('file1.xls',[9 8 10]);
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!