Excel SaveAs method and naming conventions
14 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Emily
am 21 Jun. 2022
Kommentiert: Emily
am 29 Jun. 2022
I was curious if there was a built in WB.SaveAs method and how to use it.
I'm currently using WB.Save to highlight the difference between two excel files, but wanted to have not override the original document.
Also would like the files' names to end differently as well by using the folder's names at end, as excel doesn't want to open up two files with the same names.
0 Kommentare
Akzeptierte Antwort
Image Analyst
am 21 Jun. 2022
Bearbeitet: Image Analyst
am 21 Jun. 2022
6 Kommentare
Image Analyst
am 29 Jun. 2022
Try it this way:
baseFileName = sprintf('%s_%2.2d.xlsx', fname, file_index);
fullFileName = fullfile(pwd, baseFileName);
fprintf('Saving "%s".\n', fullFileName);
WB.SaveAs(fullFileName);
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!