How do I incrementally increase an excel file everytime I run the code to avoid overwriting

6 次查看（过去 30 天）

Mohamed Sardheye 2022-10-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1816440-how-do-i-incrementally-increase-an-excel-file-everytime-i-run-the-code-to-avoid-overwriting

评论： Mohamed Sardheye 2022-10-10

I create my excel sheet using writetable(T,'Test no21.xlsx') I would like to incrementally increase the number of the excel file to avoid overwriting the previous documents, how can I achieve that?

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

请先登录，再进行评论。

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

采纳的回答

Geoff Hayes 2022-10-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1816440-how-do-i-incrementally-increase-an-excel-file-everytime-i-run-the-code-to-avoid-overwriting#answer_1065605

在 MATLAB Online 中打开

@Mohamed Sardheye - try using sprintf like

k = 22;
filename = sprintf('Test no%d.xlsx', k);
writetable(T, filename);

Or do you need to determine the 21 from the original file first?

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

Geoff Hayes 2022-10-7

在 MATLAB Online 中打开

@Mohamed Sardheye - you could use regexpi to match on the integers in your filename. Perhaps something like

filename = 'Test no21.xlsx';
newFileNumber = str2double(filename(regexpi(filename, '[0-9]'))) + 1;
newFilename = sprintf('Test no%d.xlsx', newFileNumber);