Same dimension for num and txt in xlsread

Hi,

when I read in an excel file using xlsread, I'd like to have the outputs 'num' and 'txt' to have the same dimensions. It seems to me that by default, they chop off parts on the fringe that either don't contain numerics or text. It's convenient to have the same dimensions for reference purposes. For example, txt(1,2) should give me cell B1, and num(1,2) should also give me cell B1 in the original excel file.

Thanks, Christian

[Kirby Fears]

Have you tried using the raw output of xlsread (output argument 3)? You can extract numerical and text data all from one object if you already know where (cell ranges) to find it.

[num,text,raw] = xlsread('myfile.xlsx');

[Christian]

Thank you. This works, but I have a very hard time working with 'raw'. The first column of 'raw' looks like this:

NaN
'Identifier'
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
1

and so on. It seems to be a cell. Now, I would like to find the row that has the number 1. That seems to be very tricky to do, not only because other cells might have the number 11 or so, and I only want the cell that has the number 1 and nothing else in there.

Answer 1

[Walter Roberson]

one_location = find( cellfun(@(C) isequal(C, 1), raw(:,1)) );