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!