how to find certain values in cells ?

see attached.

I am using xlsread to load data from an xls file into matlab as a cell. I would like to return all the cell values in the first column starting from row 15 until the first NaN into a variable called "List"(of type cell or integer preferably).

Answer 1

[Ghost]

Define your sheet and xlrange something similar to this

for f = 1:end;
A(:,f) = ALL(:,f);
sheet = 1;
xlRange = 'A2';
xlswrite(Exel_filename,A,sheet,xlRange)
end

[Leonardo Wayne]

Hi, thanks for your answer. My question was : Is there another way to use the cell (raw) itself. Example: raw(15: 38,1) returns the row 15 until 38 manually. I would like matlab to search for the last cell where value is not NaN which is at row 39 onwards.

[Leonardo Wayne]

never mind that I have found a way around it :)

[Ghost]

Will be good if you can share how did you solve it.