Excel SaveAs method and naming conventions

12 visualizaciones (últimos 30 días)
Emily
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.

Respuesta aceptada

Image Analyst
Image Analyst el 21 de Jun. de 2022
Editada: Image Analyst el 21 de Jun. de 2022
There is a SaveAs method. You can record a macro in Excel to see how it's typically used. Or see this:
You might also like to look at the functions strrep, fileparts, and sprintf to create new filenames.
I'm also attaching an Excel_utils class with a bunch of useful functions.
  6 comentarios
Image Analyst
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);
Emily
Emily el 29 de Jun. de 2022
Thank you everyone it works now!

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by