Selecting data from Excel sheet against input value
1 view (last 30 days)
Show older comments
Mujtaba Tahir
on 19 Mar 2020
Answered: Walter Roberson
on 23 Mar 2020
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 Comments
Accepted Answer
Walter Roberson
on 23 Mar 2020
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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!