Selecting data from Excel sheet against input value
조회 수: 2 (최근 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에서 Tables에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!