Hi Oleg Komarov, thanks for the reply.
I have many sheets in excel file and every time I want to use a particular number in every sheet. So I have to import all the sheets and run a loop. SO importdata is useful for me. I got to know how to call a particular sheet by indexing it. The following piece of CODE worked:
[type, sheets] = xlsfinfo('myfile.xlsx') ;
present = myfile.data.(char(sheets(i))) ;
Sreenu