Find all rows that contain a specific value in a excel

3 次查看（过去 30 天）
Cristian Martin
Cristian Martin 2022-5-28
评论： Voss 2022-5-28
I vave an edit text an a push button for search all rows that contain a specific value in a column
T = readtable('prices.xlsx');
item = get(handles.edit1,'String');
FinalTable = T(strcmp(T.Product, 'String', item),:);
Where is my mistake?
Error using strcmp
Too many input arguments.
If instead of using get from edit1 and use:
T = readtable('prices.xlsx');
%item = get(handles.edit1,'String');
FinalTable = T(strcmp(T.Product, 'Corn'),:);
is working

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

采纳的回答

Voss
Voss 2022-5-28
This call to strcmp:
strcmp(T.Product, 'String', item)
has an extraneous 2nd argument 'String'. It should be:
strcmp(T.Product, item)
This way, you'll notice, it conforms to the code that works, with 'Corn' being replaced by item.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

产品


版本

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by