how to get string as output from inputdlg?

6 次查看（过去 30 天）
amirhossein sarfi
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.

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

采纳的回答

Dennis
Dennis 2019-5-20
inputdlg returns a cell array and not a string.
Try
data = xlsread(filename,sheet{1},xlRange);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Migrate GUIDE Apps 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by