How to read and select data from Excel

2022 3 27
1 个回答
回答已采纳
更新时间：2022 3 28
4 次查看（30 天）

0 个投票

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?

请先登录，再回答此问题。

 采纳的回答

Mahmoud Ashraf
Mahmoud Ashraf 2022-3-27

0 个投票

t=readtable('Excel file name','Range','size');

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Ali Deniz
Ali Deniz 2022-3-28
Thank you but I want to select cl and cd values one by one. For example; I want to take cl values when the alpha is 3 or I want to take cd values when the alpha is 4. The thing I want to know how to say programme that when the alpha is 3, give the relevant cl and cd values.
Siddharth Bhutiya
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by