save data in an existing xls file but in new sheet

HI,

I would like to save (xlswrite) data in a excel file. If the files already exist, I would like to force saving the data in a new sheet that I don't really now its number.

Is this possible with matlab?

Thanks in advance!

Answer 1

[Jan]

Use xlsinfo :

[status, sheets] = xlsinfo(filename);
newSheetNumber   = numel(sheets) + 1;

[HD]

thank you, it works well !