Why does xlswrite not replace file when I tell it to?

Question

MCM 2015-11-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252404-why-does-xlswrite-not-replace-file-when-i-tell-it-to

回答： Walter Roberson 2015-11-2

I have a script that uses xlswrite to export some output. I use uiputfile to prompt my user for the filename and path for this output. If a user chooses an existing file, they are ask if they want to replace the existing file.

One of my users noticed that even through he selects "replace existing file", the file is not replaced. Instead the new output is written over what was already in the file. Which creates a big old mess.

I told him the simple fix is to just delete the file ahead of time and recreate it when the script prompts him. Or just use unique filenames. He wasn't impressed with this fix and wants me to make Matlab do it for him. (My boss, so have to).

Anyone know how to do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2015-11-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252404-why-does-xlswrite-not-replace-file-when-i-tell-it-to#answer_198223

在 MATLAB Online 中打开

uiputfile() only allows the name to be selected; it does not delete the existing file or set any flags so that routines that write files will know to overwrite the file. The code after the uiputfile() needs to delete (or rename) any existing file if the file writing code updates parts of the file.

[filename, pathstr] = uiputfile('Where do you want to write the results?');
outputfile = fullfile(pathstr, filename);
if exist(outputfile, 'file');
  delete(outputfile);
end