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 中查找有关 Tables 的更多信息

标签

产品


版本

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by