Write to Excel file using inputdlg for file name

[EDIT: 20110603 09:29 CDT - reformat - WDR]

I am trying to write to an excel file that does not exist using xlswrite. The new excel file name will be an input from the user via the inputdlg command. My issue is, xlswrite is coming back with an error saying that it needs a string and what I am giving it is a cell. Here is my code:

prompt = {'Enter excel file name:'};
dlg_title = 'Excel File Name';
num_lines = 1;
def = {'DEMO1.xls'};
file_name = inputdlg(prompt,dlg_title,num_lines,def);
var1 = 10*rand(1,10);
xlswrite(file_name,var1,1,'A2')

% class(file_name)
% 
% ans = cell

Thank you in advance for your help!

Eric

Answer 1

[Walter Roberson]

xlswrite(file_name{1},var1,1,'A2')

Answer 2

[Titus Edelhofer]

Hi Eric,

inputdlg always returns a cell array, so:

xlswrite(file_name{1}, ...)

Titus

Answer 3

[Fangjun Jiang]

Based on your code, file_name is a cell array.

use xlswrite(file_anme{1},var1,1,'A2') instead.