How to get column and row number while searching for specific text in excel.
16 次查看(过去 30 天)
显示 更早的评论
Get column number and Row number from excel with matched input text
0 个评论
回答(1 个)
Astarag Chattopadhyay
2017-11-10
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!