MATLAB Answers

how to find certain values in cells ?

2 views (last 30 days)
Leonardo Wayne
Leonardo Wayne on 18 Apr 2016
Commented: Ghost on 20 Apr 2016
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).

Accepted Answer

Ghost
Ghost on 18 Apr 2016
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
  3 Comments
Ghost
Ghost on 20 Apr 2016
Will be good if you can share how did you solve it.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!