Excel SaveAs method and naming conventions

2022 6 21
1 个回答
回答已采纳
更新时间：2022 6 29
8 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

 采纳的回答

Image Analyst
Image Analyst 2022-6-21
编辑：Image Analyst 2022-6-21

0 个投票

There is a SaveAs method. You can record a macro in Excel to see how it's typically used. Or see this:
https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas
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 个评论
显示 4更早的评论 隐藏 4更早的评论

Emily
Emily 2022-6-27
Hi, I read through the link and some other similar questions posted here and tried to use the code below, but still having trouble saving it as a new excel file.
WB.SaveAs([pwd,'\',xls_fname,'_',file_index,'.xlsx'])
Emily
Emily 2022-6-28
Hi, I looked at the code written and ran the example problem.
But I'm still having trouble with the saveas portion
This is my current code
NewExcel=char(pwd,'\',fname,'_',num2str(file_index),'.xlsx');
NewExcel=reshape(NewExcel',1,[]);
WB.SaveAs(NewExcel);
Maybe the way I wrote NewExcel is wrong?
Walter Roberson
Walter Roberson 2022-6-29
Why are you doing that reshape() of the file name?
Note: I recommend that you use fullfile()
Image Analyst
Image Analyst 2022-6-29
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 2022-6-29
Thank you everyone it works now!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by