Selecting data from Excel sheet against input value

Question

Mujtaba Tahir 2020-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511813-selecting-data-from-excel-sheet-against-input-value

回答： Walter Roberson 2020-3-23

universal_beam_data.xlsx

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.

4 个评论
显示 2更早的评论隐藏 2更早的评论

darova 2020-3-20

Look into xlsread and strcmp

Mujtaba Tahir 2020-3-23

I have tried looking into it but main problem is substituting variables with values of beam properties

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-3-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511813-selecting-data-from-excel-sheet-against-input-value#answer_421397

在 MATLAB Online 中打开

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      