How to import data from multiple sheets in excel, then select specific columns, and then select a specific range of the data ?

I have an excel document with 5 sheets.

1. First I want to import the data from all the sheets.
2. Then I want to select columns 10 and 11 from each sheet. Column 10 is time in minutes (0-180 minutes) and column 11 is the data.
3. Lastly I want to select data from 30-60 minutes, and compare it to the data from 150-180 minutes in different plots for each of the 5 sheets.

Answer 1

[Harry Vancao]

The function "xlsread" is able to read in the data from a sheet in an excel file. You can specify each sheet to read in through the second argument. You can manipulate the data from there.

>> raw = xlsread('myexcelspreadsheet.xlsx', 1); % read in sheet number 1

>> time = raw(:, 10);

>> data = raw(:, 11);

>> plot(time(30:60), data(30:60));

For more information on "xlsread" please consult the following documentation:

https://www.mathworks.com/help/matlab/ref/xlsread.html