Xlsread for a particular column returns values from another column too?

Question

Soumyatha Gavvala 2016-6-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/290519-xlsread-for-a-particular-column-returns-values-from-another-column-too

编辑： Shameer Parmar 2016-6-18

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 个评论
显示 3更早的评论隐藏 3更早的评论

dpb 2016-6-17

Well, it's not possible to diagnose the problem without the .xls file; there doesn't appear to be any coding error in the code snippet you've shown; xlsread is documented to read a range without a sheet name when given a 'C1:C2' range so afaik the 'C:C' specification works in what testing I've done here. You can try the other respondent's suggestion (as mine in the previous thread) of using the explicit sheet name and see if that does solve anything but my guess is it won't because that's not the issue but it is something beyond what's shown here.

Alternatively, and perhaps still as fast or faster than opening the spreadsheet twice with xlsread, use it only once and read the full sheet (or the range 'X:AD' and then use array indexing in memory to address the wanted columns (which would be more nearly "the Matlab way" as I've also alluded to in previous thread).

How do you know something came from column 'A', btw, and not the issue as mentioned earlier regarding floating point comparison or other unknown issues?

Soumyatha Gavvala 2016-6-17

Hi,

I fixed this by just selecting the larger set of elements from the column which I need. But if you do find a solution for this situation, feel free to post it. Thank you.

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.

请先登录，再进行评论。

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

Answer 1

Shameer Parmar 2016-6-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/290519-xlsread-for-a-particular-column-returns-values-from-another-column-too#answer_225877

编辑：Shameer Parmar 2016-6-18

在 MATLAB Online 中打开

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);