Plotting single graphs per excel sheet

1 view (last 30 days)
Veena Sanmugananthan
Veena Sanmugananthan on 14 Oct 2019
Answered: darova on 15 Oct 2019
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

Answers (1)

darova
darova on 15 Oct 2019
Look HERE how to count sheets in excel

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!