Excel SaveAs method and naming conventions
12 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Emily
el 21 de Jun. de 2022
Comentada: Emily
el 29 de Jun. de 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 comentarios
Respuesta aceptada
Image Analyst
el 21 de Jun. de 2022
Editada: Image Analyst
el 21 de Jun. de 2022
6 comentarios
Image Analyst
el 29 de Jun. de 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);
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!