Can xlswrite be used to prompt the user for the file name?

Question

David Hughes 2015-8-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/232019-can-xlswrite-be-used-to-prompt-the-user-for-the-file-name

评论： Image Analyst 2015-8-2

I have a script that writes the results to an excel file. Currently the file name has to be entered into the script. I want the user to enter the name when prompted by the script. How can I this be done?

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2015-8-1

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/232019-can-xlswrite-be-used-to-prompt-the-user-for-the-file-name#answer_187947

在 MATLAB Online 中打开

Try this:

% Get the name of the file that the user wants to save.
startingFolder = userpath % Or pwd, or wherever you want it to start at.
defaultFileName = fullfile(startingFolder, '*.xlsx');
[baseFileName, folder] = uiputfile(defaultFileName, 'Specify a filename ');
if baseFileName == 0
  % User clicked the Cancel button.
  return;
end
% Combine the folder and base file name into the full file name.
fullFileName = fullfile(folder, baseFileName)
% Write the data out to the filename the user has chosen.
xlswrite(fullFileName, data);