convert cell array to double error: Dimensions of arrays being concatenated are not consistent.

I have a cell array like this:

T_input_mod =

{'456358'}

{'0' }

{'0' }

{'457' }

{'0' }

When I use this:

a = str2num(cell2mat(T_input_mod))

I encounter this error:

Error using cat

Dimensions of arrays being concatenated are not consistent.

Error in cell2mat (line 83)

m{n} = cat(1,c{:,n});

What should I do?

Answer 1

[Simon Chan]

Use function str2double

[Robert]

It has problem with cell2mat function in first place.

[Simon Chan]

They are character array inside the cell. The length of each chaacter is different as shown in the following. And function cell2mat will gives an error

T={'456358';'0';'0';'457';'0'};
cellfun('length',T)

ans = 5×1

6 1 1 3 1

If the length of all character are the same, you are able to use function cell2mat as shown in the following:

T2={'4';'0';'0';'7';'0'};
cell2mat(T2)

ans = 5×1 char array
    '4'
    '0'
    '0'
    '7'
    '0'

[Robert]

I call it from an Excel with 10000 rows. I cant load it separately. Is there any solution to solve this?

[Simon Chan]

Use function str2double

T={'456358';'0';'0';'457';'0'};
a = str2double(T)

a = 5×1

456358 0 0 457 0

[Stephen23]

"I call it from an Excel with 10000 rows. I cant load it separately. Is there any solution to solve this?"

Probably you should use READTABLE or READMATRIX or READCELL to avoid this situation in the first place.

Please upload your Excel file by clicking the paperclip button.

[Robert]

Thank you Simon. It worked with "str2double"