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?
Best Answer