Xlsread for a particular column returns values from another column too?
1 次查看(过去 30 天)
显示 更早的评论
Hello,
I want to obtain the row indices of cells from the Column AD with a particular value, Column X with a particular value, and get the common indices in another array.Here's the code I used:
%Read data1 and select files with the corresponding value
MyData1=xlsread(FileName,'AD:AD'); % read the column
[ir,ic]=find(MyData==2.5); % row, column indices
%Read data 2 and select files with the corresponding value
MyData2=xlsread(FileName,'X:X'); % read the column
[er,ec]=find(MyData2==49);
%Select common files
files=intersect(ir,er);
But, I am getting indices of rows that have these values from another column, here AA. Which I have not specified anywhere. Is there any error in my code?
Thank you.
5 个评论
dpb
2016-6-17
I don't think there is a "situation"; I think there's an error somewhere in the previous work outside what was posted here that we could see that explains the problem you're having.
回答(1 个)
Shameer Parmar
2016-6-17
编辑:Shameer Parmar
2016-6-18
MyData1 = xlsread(fileName,'Sheet1','AD:AD');
ir = find(ismember(MyData1,2.5));
MyData2 = xlsread(fileName,'Sheet1','X:X');
er = find(ismember(MyData2,49));
files=intersect(ir,er);
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!