How do I incrementally increase an excel file everytime I run the code to avoid overwriting
4 views (last 30 days)
Show older comments
Mohamed Sardheye on 3 Oct 2022
Commented: Mohamed Sardheye on 10 Oct 2022
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 on 3 Oct 2022
@Mohamed Sardheye - try using sprintf like
k = 22;
filename = sprintf('Test no%d.xlsx', k);
Or do you need to determine the 21 from the original file first?
More Answers (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!