Dear i have an .xslx file with 30 different sheets. From Sheet 3 to 30 i want to return 2 plots per sheet.
Excelfile name is: TEST12_St.xlsx
Name of the sheet number 3 is: Test12_1
Name of the sheet number 4 is: Test12_2
Name of the sheet number 30 is: Test12_28
x_axis: represents time in seconds and always in the B columne for the sheets (3 to 30). ploting should start from cell number 18 (ends differently at differnt sheets).
y_axis for Plot 1: is column D also from cell number 18
y_axis for Plot 2: is column E and F (need to be in different colors)
Please see the attached simplified Exce file.
I tried to start with the following code but I failed (Note: I am trying to learn and use Matlab to make my works easier)
% This one only read two columnes in Test sheet Test12_1
[Y, M, D, H, MN, S] = datevec(B);
h = plot(B,D)