Why does xlswrite not replace file when I tell it to?
显示 更早的评论
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?
采纳的回答
Walter Roberson
2015-11-2
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
更多回答（1 个）
TastyPastry
2015-11-2
0 个投票
You could fill the file with empty cells, or there's a solution here. Scroll down to the solution by ImageAnalyst.
类别
在 帮助中心 和 File Exchange 中查找有关 Standard File Formats 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
