how to read a excel file by taking user input in dialog box

1 次查看（过去 30 天）
Ravikant Singh
Ravikant Singh 2014-3-7
回答： Image Analyst 2014-3-8
program
prompt='enter file name'; dlg_title='file name'; num_lines=1; a=input(prompt,dlg_title,num_lines);
prompt='enter sheet name'; dlg_title='Sheet name'; num_lines=1; b=input(prompt,dlg_title,num_lines);
[data,header]=xlsread(a,b);
i am getting an error "Filename must be string"
  6 个评论
显示 4更早的评论
Chandrasekhar
Chandrasekhar 2014-3-7
you can take it as an input , Also you can use activex server commands to display all the sheets existing in that xls

请先登录，再进行评论。

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

回答（1 个）

Image Analyst
Image Analyst 2014-3-8
If you want to know how to control Excel with ActiveX, see my attached demo. You can do a lot more than is in my demo, such as getting all the sheet names, etc.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by