calling specific sheet of excel after importdata

Hi I have a excel file with around 20 sheets. I am importing data using mydata = importdata('myfile.xlsx') ;

    Now mydata is a structure. This has two substructures; data and textdata. Using mydata.data I am able to get the sheets which are present in the excel file. I want to run a loop such that I can call the specific sheet from mydata.data . Is there any way to do this?

Thanks in advance

Sreenu

Answer 1

[KSSV]

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

Answer 2

[Oleg Komarov]

Yes, use xlsread within a for loop specifying the sheet to import.

for s = 1:20
    data.(mydata.data{s}) = xlsread('C:...filename',mydata.data{s})
end