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..?

Answer 1

[KSSV]

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]);

[mano49j]

It can be done that way. But, I am looking for something which can be specified as input parameter to xlswrite which does the same..