save data in an existing xls file but in new sheet

4 次查看（过去 30 天）

HD 2016-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282156-save-data-in-an-existing-xls-file-but-in-new-sheet

评论： HD 2016-5-4

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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Jan 2016-5-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282156-save-data-in-an-existing-xls-file-but-in-new-sheet#answer_220423

在 MATLAB Online 中打开

Use xlsinfo :

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

HD 2016-5-4

thank you, it works well !

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by