MATLAB: How to find certain values in cells

cell find

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).

Best Answer

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

Related Solutions

MATLAB: How to write data to excel without overwrite data that already in the excel

To write in the empty rows, you have to specify that to xlswrite. So, either you know the row number beforehand and use that 'xlRange' to write the variable 'A'. Example:

filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
empty_row = 10
xlRange = ['A',num2str(empty_row)];
xlswrite(filename,A,sheet,xlRange)

Or if you don't know the row number beforehand you can count the filled rows inside the file using xlsread. Example:

filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
[~,~,ev] = xlsread(filename,sheet); % ev is cell array containing every filled row and column
empty_row = size(ev,1) + 1; 
xlRange = ['A',num2str(empty_row)];
xlswrite(filename,A,sheet,xlRange)

I hope it helps !

MATLAB: Xlswrite not writing few entries

From

doc xlswrite
...
Input Arguments
...
A — Data to writematrix | cell array
Data to write, specified as a two-dimensional numeric or character array, or, if each cell
contains a single element, a cell array.
If A is a cell array containing something other than a scalar numeric or a string, 
then xlswrite silently leaves the corresponding cell in the spreadsheet empty.

It seems there must be that there's something not meeting that criterion in the cell array.

Best Answer

Related Solutions

MATLAB: How to write data to excel without overwrite data that already in the excel

MATLAB: Xlswrite not writing few entries

Related Question