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

4 Ansichten (letzte 30 Tage)
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?

Akzeptierte Antwort

Geoff Hayes
Geoff Hayes am 3 Okt. 2022
@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 Kommentare
Geoff Hayes
Geoff Hayes am 7 Okt. 2022
@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);

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by