Reading excel file sheets

How to read sheets of an excel file and save it. also I want to access these sheets inside a for loop for further analysis and plottig.

I have done like this.

filename = 'timeframe_wodsm.xls';
VHC = xlsread(filename,1);
HC = xlsread(filename,2);
MC = xlsread(filename,3);
LC = xlsread(filename,4);

Here I am getting 4 different files for each sheets,

For further analysis, logic is the same but i have to repeat it for 4 times. How to keep it in a loop?

Also how to plot 4 graphs for each of the sheets inside the loop itself?

[laurent jalabert]

d = uigetdir(pwd, 'Select a folder');
DATA = dir(fullfile(d, '*.xlsx'));
[status,sheets] = xlsfinfo(DATA.name);
sheets = sheetnames(DATA.name); 
for ii=1:length(sheets)
    EachSheet{ii} = readtable(DATA.name,'Sheet',ii); 
end

Answer 1

[KSSV]

It is suggested to use readtable instead.

filename = 'timeframe_wodsm.xls';
data = = cell(4,1) ; 
for i = 1:4
    data{i} = xlsread(filename,i);
end

[NETHRAVATHI S]

Thank you for your answer.

It helped.