Single Excel (.xslx) with multiple sheets need to plot some columnes.

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

Plot information:

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

T=xlsread('TEST12_St.xlsx','Test12_1')

B=T(:,2);

[Y, M, D, H, MN, S] = datevec(B);

H*3600+MN*60+S

B=ans;

D=T(:,3);

figure

h = plot(B,D)

Answer 1

[drummer]

I encourage you to use readtable rather than xlsread. You can always use the importTool as well.

However, readtable is for a single spreadsheet. You'd do it for every single sheet you wanna read.

Instead, try spreadSheetDatastore, then you can access all of your sheets at once.

Afterwards, you can play with the variable names (columns) in the data you wanna extract.

Cheers

Answer 2

[Sunil Patidar]

Hi,

You can use xlsinfo function to read the file. Then, use xlsread function to read the content of the sheet.

refer to the following MATLAB Answeres link for more details:

https://www.mathworks.com/matlabcentral/answers/496849-create-loop-for-multiple-excel-sheets-documents?s_tid=srchtitle

[Harr]

Dear drummer and Sunil Patidar, thank you very much for your replies!

[Peter Perkins]

drummer is correct. Strongly prefer readtable (or readmatrix) over xlsread. xlsread is old and far less capable than readtable.