Printing specific rows based on column from excel

2022 4 11
1 个回答
回答已采纳
更新时间：2022 4 12
7 次查看（30 天）

0 个投票

Good Day,
I have an excel sheet with 7296 rows and 9 columns. So, I want to get certain rows only based on the column value. For example:
Time Node FaceID FaceDescr Type Packets Kilobytes PacketsRaw KiloBytesRaw
Like the above snippet I have certain rows with the FaceDesc 'ALL' as one of the columns. So, I want my code to print only those rows. I have some unecessary rows that I don't want the code to print like the below screenshot shows. Can anyone please nudge towards the right direction of getting what I need? I'm new to MatLab. Thank you.

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

 采纳的回答

KSSV
KSSV 2022-4-11

0 个投票

T = readtable(myfile) ;
idx = matches(T.FaceDescr,'all') ;
T(idx,:)

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

Thank you so much! Works perfectly.
@KSSV For suppose, If I want my code to print all the rows under FaceDescr:'appFace:// ' and Type: 'InInterests'. How can I do that?
KSSV
KSSV 2022-4-12
Get indices of each column and use logical and.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by