MATLAB: Cell contents reference from a non-cell array object

excelMATLAB

I am trying to plot several graphs using data from excel. I tried using cell2mat but it gives me this error. Can someone clarify this?

Best Answer

xlsread can return up to 4 outputs, The first of the outputs, the one you have called num, is always a numeric array, never a cell array. There is no need to call cell2mat() there as it is already a numeric array.

Related Solutions

MATLAB: How to merge a cell 2×60 into 1×60

One possible way:

newcellarray = cellfun(@(column) cell2mat(column), num2cell(yourcellarray, 1), 'UniformOutput', false);

MATLAB: Cell contents reference from a non-cell array object.

Each cell of v contains a numeric vector. So your indexing here:

v{1}{k+1} = v{1}{k+1}-1
%   ^   ^       ^   ^ wrong type of bracekts for numeric array.

uses the wrtong type of brackets for indexing (curly braces are used to access the elements of a container array, e.g. the elements of a cell array, table, or string). The correct brackets for accessing the elements of a numeric array are parentheses, as shown here:

vchave = [2,2,2,2,2,2];
for k = 1:5;
    v{k} = vchave
    v{1,k} = v{1,k}-1
    v{1}(k+1) = v{1}(k+1)-1
end
v = 1x1 cell array
    {1×6 double}
v = 1x1 cell array
    {1×6 double}
v = 1x1 cell array
    {1×6 double}
v = 1x2 cell array
    {1×6 double}    {1×6 double}
v = 1x2 cell array
    {1×6 double}    {1×6 double}
v = 1x2 cell array
    {1×6 double}    {1×6 double}
v = 1x3 cell array
    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x3 cell array
    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x3 cell array
    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x4 cell array
    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x4 cell array
    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x4 cell array
    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x5 cell array
    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x5 cell array
    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}
v = 1x5 cell array
    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}    {1×6 double}

I strongly recommend preallocating v before the loop.

Best Answer

Related Solutions

MATLAB: How to merge a cell 2×60 into 1×60

MATLAB: Cell contents reference from a non-cell array object.

Related Question