How to read and select data from Excel

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?

Answer 1

[Mahmoud Ashraf]

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

[Ali Deniz]

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]

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

[Ali Deniz]

Thank you so much