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

11 ビュー (過去 30 日間)
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 日
@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 件のコメント

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by