Write data to new excel file
显示 更早的评论
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..?
回答（1 个）
KSSV
2016-12-15
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]);
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
