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

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"

[ES]

You could use uigetfile instead. That will save you from unkonown file, path issues etc.

[Ravikant Singh]

it will only read excel file

[Chandrasekhar]

you have to use a filter as given below

uigetfile('*.xls')

[Ravikant Singh]

it is working thnx but what about a sheetname can we take input by using dialog box???

[Chandrasekhar]

you can take it as an input , Also you can use activex server commands to display all the sheets existing in that xls

[Ravikant Singh]

how??

Answer 1

[Image Analyst]

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.