MATLAB: Selecting data from Excel sheet against input value

MATLABselect data from table

I have a excel sheet which has four columns.1st column contains names of beams and other contains properties corresponding to it. I want to create a function or a script which asks user to input a beam name. Search the table if the beam exists. If it does it should put the properties of that beam equal to different variables.

Best Answer

Use readtable() to read in the xlsx
ismember() the beam name against the first column of the table, giving a logical vector.
Use the vector as the row index into the table.
The result will be a table with 2 rows and the appropriate number of columns. You can extract portions of that table. For example,
YourSubTable{2,3}     %second Ix value for the beam
The table will have two rows because each name is repeated on two lines. For example,
  2×4 table
    Designation    mass per length (kg/m)    Ix (x10^6 mm^4)    Zx (x10^3 mm^3)
    ___________    ______________________    _______________    _______________
     {'150UB'}               18                   9.05                117      
     {'150UB'}               14                   6.66               88.8
Related Question