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.
- First I want to import the data from all the sheets.
- 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.
- 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.
0 个评论
回答(1 个)
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:
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!