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

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?

Answer 1

[Geoff Hayes]

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

[Mohamed Sardheye]

@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]

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

[Mohamed Sardheye]

Thank you @Geoff Hayes