MATLAB Answers

0

Plotting single graphs per excel sheet

Asked by Veena Sanmugananthan on 14 Oct 2019
Latest activity Answered by 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

  0 Comments

Sign in to comment.

1 Answer

Answer by darova
on 15 Oct 2019

Look HERE how to count sheets in excel

  0 Comments

Sign in to comment.