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

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?

Answer 1

[Image Analyst]

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);

Answer 2

[Jon]

This code will request user input for the name:

str = input('Enter filname:','s')

Then you can simply pass the str variable into xlswrite:

xlswrite(str,A)

Is that what you're asking?

[David Hughes]

Yes this what I wanted. Also I am looking for the prompt to be a dialog box.

[Image Analyst]

That's what I gave you. Did you overlook my answer below?

Answer 3

[Jan]

Use uigetfile, if the file is existing already and the data should be appended, and uiputfile if the file should be created or overwritten.