Info

此问题已关闭。 请重新打开它进行编辑或回答。

equivalence of the codes that can be used for erasing the first row of R if cell R(1,3) is occupied by NaN?

1 次查看(过去 30 天)
Dear all,
Could you please verify the equivalence of the codes that can be used for erasing the first row of R if cell R(1,3) is occupied by NaN?
Code 1:
[N,T,R] = xlsread(xlfilename);
if isnan(cell2mat(R(1,3)))
R(1,:)=[];
End
Code 2
TT = cellfun( @isnan, R(1,3), UniformOuput, true);
R( ( TT,1), : ) = [] ;

回答(1 个)

F.
F. 2012-7-5
I'm sorry but I don't understand what you are looking for. Code 2 is the code that I gave you http://www.mathworks.fr/matlabcentral/answers/42710-problem-with-xlsread-bizarre-results
R is the raw output of the xlsread function. In each cell, there is a numeric or a string. So R(1,3) is a cell, and you are checking one value to erase the column of your cell array. In code 2 you are using a command (cellfun)used to manage cell arrays just for one cell, and after, you don't use TT !!
*for erasing the first row of R if cell R(1,3) is occupied by NaN *
if all(isnan( R{1,3} ))
R(1,:) = []
end

此问题已关闭。

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by