Plotting single graphs per excel sheet

Hi all,

I'm trying to create a different figure for each excel sheet that my code runs through.

My code is able to plot one graph for one sheet, but doesn't plot anymore than that.

If someone could help me figure out what I'm missing that would be great!

files = dir(fullfile('D:\Thesis\Reports\Encoding\Encoding Trial Reports\Free viewing Reports\Run1', '*.xlsx'));

L = length(files);

for i=1:L

file=files(i).name;

data = xlsread(files(i).name);

x=data(:,1);

y=data(:,9);

plot(x,y)

hold off

end

Answer 1

[darova]

Look HERE how to count sheets in excel