Looking for empty spaces in input array from excel
显示 更早的评论
I read data from an excel file with both text and numerical data, and I would like to detect the empty spaces between the rows. When I perform the command:
[NUMM,STRR,RAWW]=xlsread(InputFile,1);
indx=cellfun(@isnan,RAWW(:,1),'uni',false)
I get another cell array that looks like:
[1×14 logical]
[1×10 logical]
[1×10 logical]
[1×20 logical]
[1×9 logical]
[ 1]
[ 1]
[1×43 logical]
[1×16 logical]
[1×10 logical]
[1×20 logical]
[1×10 logical]
But I cannot find the location of the "1" in this array. I tried e.g. cell2mat but it doesn't covert the arrays into numerical ones. How can I solve this problem?
采纳的回答
Harish Ramachandran
2018-2-2
You can use the find command:
c = {[5 5 5],1,1,1,1,1,1}
indx = find([c{:}] == 1)
c =
1×7 cell array
{1×3 double} {[1]} {[1]} {[1]} {[1]} {[1]} {[1]}
index =
4 5 6 7 8 9
Reference:
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
