MATLAB: How to write a table to a user specified excel file name/directory

excelinpputinputuixlsxlswrite

How would I go about creating a program that writes some arbitrary table, A, to a user specified Excel file? I tried using different UI commands, but I can't seem to get them to work. Essentially what I need is to allow a user to choose where the excel file is written and what the name of the file is.

Best Answer

I believe you want the function uiputfile. It will open a dialog in which the user can select a path and name for a new file. You could use the returned values with writetable to save your data to the new Excel file.

Related Solutions

MATLAB: XLSWRITE

name = inputdlg('Name excel file as: ','Name excel',1);

MATLAB: Asking for filename of excel sheet then using xlsread to display

You need to define the behaviour you want when the user does not enter a valid file name, as in this case.

When you do not provide a file extension, xlsread will assume .xls . If you want to prevent that, and have it attempt to open the name with no extension, then add a '.' on to the end of the name, as in

xlsread([A '.'])

I would suggest you do input validation before you invoke xlsread to ensure that the name the user gave matches an actual file. You need to decide whether you want to force the user to give a full extension, and if not then you need to decide what order of extensions you want to try.

Might I suggest that this problem would be reduced if you were to use uigetfile() instead of input() to get the file names?

Best Answer

Related Solutions

MATLAB: XLSWRITE

MATLAB: Asking for filename of excel sheet then using xlsread to display

Related Question