How to get column and row number while searching for specific text in excel.

Question

Priyanka P 2017-11-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364689-how-to-get-column-and-row-number-while-searching-for-specific-text-in-excel

评论： Priyanka P 2018-3-11

Get column number and Row number from excel with matched input text

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Astarag Chattopadhyay 2017-11-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364689-how-to-get-column-and-row-number-while-searching-for-specific-text-in-excel#answer_290338

在 MATLAB Online 中打开

Hi,

You can use the following code snippet to find out the column number and the row number of a matching string in an Excelsheet:

 [data,txt] = xlsread('filename.xlsx');
 num = find(contains(txt(:,:),'string to find'));
 colNum = ceil(num/s(1))
 rowNum = num - s(1)*(colNum-1)

Here give your Excel file name as the input in "xlsread". 'txt' contains all the data as xell array. 'num' finds the location of the string (assumption: the string is present within the file). 'colNum' and 'rowNum' calculates the corresponding column and row number of the string.