read selected data from excel datasheet using if statement

Question

Abhishek 2019-5-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/464384-read-selected-data-from-excel-datasheet-using-if-statement

回答： Utkarsh Belwal 2019-6-24

testfile.xlsx

if have a excel file " testfile" for which i have to slect some data using if statement

i want to read column 4th, 5th and 9th coloumn of this file starting from where coloumn 1 values are >=14 and read it till where cloloum 1 value is <= 16

I have tried the code but it didnot work

A = xlsread('testfile.xlsx')

if (A(:,2)>=14)

then

if(A(:,2)<=15)

then

B = A(:,4);

C = A(:,5)

D = A (:,9)

end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Utkarsh Belwal 2019-6-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/464384-read-selected-data-from-excel-datasheet-using-if-statement#answer_380506

A(:,2) >= 14 will give a matrix of 0s and 1s, if statement will execute only if A(:,2) >= 14 returns a matrix which has all 1s and according to your xlsx sheet that is not the case so if statement will never be true. Although you can try this code,

A = xlsread('testfile.xlsx') ;

ind = A(:,1) >= 14 & A(:,1) <= 16 ;

B = A(ind , 4) ;

C = A(ind , 5) ;

D = A(ind , 9) ;