How to read and select data from Excel
4 ビュー (過去 30 日間)
古いコメントを表示
I have an excel data in the following. How can I select the data from this excel table. For example; how can I select the Cl and Cd values while alpha changes?
0 件のコメント
採用された回答
Mahmoud Ashraf
2022 年 3 月 27 日
t=readtable('Excel file name','Range','size');
3 件のコメント
Siddharth Bhutiya
2022 年 3 月 28 日
You could read the excel file into a MATLAB table as mentioned above using readtable. Once you have the table, you can use subscripting based on your desired condition to select the appropriate values.
>> t
t =
11×3 table
alpha Ci Cd
_____ _______ ________
0 0.48812 0.44681
0.5 0.97057 0.012023
1 0.56811 0.034271
1.5 0.27397 0.39877
2 0.12908 0.97945
2.5 0.15519 0.54277
3 0.26881 0.91239
3.5 0.43389 0.32416
4 0.3959 0.29052
4.5 0.42525 0.87897
5 0.61439 0.77914
>> t(t.alpha == 3,:) % Select rows where alpha is 3
ans =
1×3 table
alpha Ci Cd
_____ _______ _______
3 0.26881 0.91239
>> t(t.alpha > 2.5,:) % Select rows where alpha is greater than 2.5
ans =
5×3 table
alpha Ci Cd
_____ _______ _______
3 0.26881 0.91239
3.5 0.43389 0.32416
4 0.3959 0.29052
4.5 0.42525 0.87897
5 0.61439 0.77914
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!