how to select numbers within the required range from one column in the excel

Question

Tian Tian 2018-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/382729-how-to-select-numbers-within-the-required-range-from-one-column-in-the-excel

评论： Tian Tian 2018-2-15

Hi everyone, I want to read the data from one column in excel file, and select the data within a certain range. The number of selected data is supposed to save in sheet 2. Here is my code:

sym Na;

    Xa=xlsread(excelfilename,'A:A');
    for i = 1:nrows
        if (Xa > 4154 & Xa <= 103854)
           Na=Na+1; 
        end
    end
xlswrite(excelfilename,Na,'Sheet2','B2:B2')

But there is a problem causing the 'Na' to be 0 all the time. Does anyone know the problem with my code? I appreciate your time and help.

2 个评论
显示无隐藏无

Bob Thompson 2018-2-14

在 MATLAB Online 中打开

Your if statement is examining the entire array of Xa, rather than the individual rows, which I assume is what you're trying to do. You need to add indexing to your Xa call to examine each row.

if (Xa(i) >4151 && Xa(i) <= 103854)

Tian Tian 2018-2-15

Thank you Bob Nbob!

请先登录，再进行评论。

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

Answer 1

Rik 2018-2-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/382729-how-to-select-numbers-within-the-required-range-from-one-column-in-the-excel#answer_305207

在 MATLAB Online 中打开

In addition to the remark Bob made, you can also remove the loop and check the entire row in one go:

Xa=xlsread(excelfilename,'A:A');
Na=sum(Xa > 4154 & Xa <= 103854);
xlswrite(excelfilename,Na,'Sheet2','B2:B2')

PS pre-allocating Na to a sym doesn't make sense if you are just going to add it up and write it as a numeric value. Just pre-allocate to 0 if you're using a loop.