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

2022 10 3
1 个回答
回答已采纳
更新时间：2022 10 10
3 次查看（30 天）

0 个投票

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?

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

 采纳的回答

Geoff Hayes
Geoff Hayes 2022-10-3

1 个投票

@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更早的评论

Mohamed Sardheye
Mohamed Sardheye 2022-10-4
@Geoff Hayes, yes, I need to determine the 21 from the original file and then automatically save the new document as 22, so if my document no34, I need it read and then saved as 35.
Geoff Hayes
Geoff Hayes 2022-10-7
@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);

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by