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

1 次查看(过去 30 天)
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.

回答(1 个)

Harry Vancao
Harry Vancao 2019-1-29
编辑:Harry Vancao 2019-1-29
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:

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by