Selecting data from Excel sheet against input value
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Walter Roberson
2020-3-23
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
0 个评论
更多回答(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!