Find string in excel file

2018 6 25
2 个回答
更新时间：2020 4 29
11 次查看（30 天）

0 个投票

Hello
i have got an excel file with this coloum example:
T_DCT_PK_WDT_W01B1_RANGE
T_DCT_PK_WDT_W01B2_RANGE
T_DCT_PK_WDT_W02B1_RANGE
T_DCT_PK_WDT_W02B2_RANGE
and so on.
Now i would like to search for example T_DCT_PK_WDT_W01B2_RANGE
So if(T_DCT_PK_WDT_W01B2_RANGE is found) then ....
how can i do this? This doesnt work for me:
num = xlsread ( 'T_APC_RUNKEYNUMBER_test.xlsx' );
k = strfind(num, 'T_DCT_PK_WDT_W01B2_RANGE');

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

回答（2 个）

Paolo
Paolo 2018-6-25
编辑：Paolo 2018-6-25

0 个投票

text = {'T_DCT_PK_WDT_W01B1_RANGE';
'T_DCT_PK_WDT_W01B2_RANGE';
'T_DCT_PK_WDT_W02B1_RANGE';
'T_DCT_PK_WDT_W02B2_RANGE'}
indx = strcmp(text,'T_DCT_PK_WDT_W01B2_RANGE')
if any(indx)
%your logic
end

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Adrian Pielmeier
Adrian Pielmeier 2018-6-25
why are u doing the text={...} i need to find the strings in my excel coloum this is how i read it:
[fileName,dirName]=uigetfile('T_APC_RUNKEYNUMBER_test.xlsx.xlsx');
[~,~,rawData] = xlsread(fullfile(dirName,fileName));
Paolo
Paolo 2018-6-25
It was an example, I assumed that you had read the excel file successfully already. You should be able to replace 'text' with raw.
From the documentation for raw:
Numeric and text data from the worksheet, returned as a cell array.
Adrian Pielmeier
Adrian Pielmeier 2018-6-25
replacing the text with rawData i get the following error
Error using strfind Cell input must be a cell array of strings.
Paolo
Paolo 2018-6-25
Do you have numerical values in your data, too?
Adrian Pielmeier
Adrian Pielmeier 2018-6-25
this is how my excel looks like this is a screenshot from the matlab clicking workspace/rawData
Paolo
Paolo 2018-6-25
Search for the string in the first column only, raw(:,1)
Adrian Pielmeier
Adrian Pielmeier 2018-6-25
Now it looks like this:
[fileName,dirName]=uigetfile('T_APC_RUNKEYNUMBER_test.xlsx');
[~,~,rawData] = xlsread(fullfile(dirName,fileName));
rawData (:,1);
indx = strcmp(rawData,'T_DCT_PK_WDT_W01B1_RANGE');
if any(indx)
fprintf('Correct');
end
but eventho there is a cell with T_DCT_PK_WDT_W01B1_RANG there is no printf
Paolo
Paolo 2018-6-25
indx = strcmp(rawData(:,1),'T_DCT_PK_WDT_W01B1_RANGE');
Rohan Singla
Rohan Singla 2020-4-29
can we also find the row and column number at which our string was present?

请先登录，再进行评论。

Ahmed Elsherif
Ahmed Elsherif 2018-11-23

0 个投票

Hi,
I have something similar as I am looking for a value under a certain header in GUI. In principle, it works but it prints a wrong value! I mean it shows the value in the third column after the desired one although it prints '1' for the correct position.
Whould you please help me why?
Thanks in advance.
My sub-code is:
handles.fileName = uigetfile ('.xlsx')
[data, text] = xlsread('input');
idx = strcmpi(text(1,:),'headertobefound')
k=data(:,idx);
set(handles.edit40,'string',k);

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by