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!