how to get string as output from inputdlg?

Question

amirhossein sarfi 2019-5-20

评论： amirhossein sarfi 2019-5-20

Hi everyone,

In the following script when I am trying to get sheet name from user by inputdlg as string to use for xlsread gives me the error:

Error using xlsread (line 146)

Sheet argument must be a string scalar, a character vector, or an integer.

Error in try_input (line 17)

data = xlsread(filename ,sheet ,xlRange);

the related scripts is:

sheet = inputdlg('Enter the input sheet name please:',...

'Input', [1 50]);

xlRange = 'D2:E44509';

data = xlsread(filename ,sheet ,xlRange);

Thanks.

Answer 1

Dennis 2019-5-20

inputdlg returns a cell array and not a string.

Try

data = xlsread(filename,sheet{1},xlRange);

Thanks for your help.