Hi. I have different data types (text and numeric) within the array range that I read from the input table. How can I avoid the error of using table2array and cell2mat?

xlFiles = dir('*.xlsx');

N = length(xlFiles);

Tmat = cell(N,1) ;

for i = 1:N

thisFile = xlFiles(i).name;

T = readtable(thisFile,'Range','a3:u29','ReadVariableNames',false);

Tmat{i} = table2array(T);

end

Tmat = cell2mat(Tmat) ;

xlswrite('allmodel2010to2039.xlsx',Tmat);

Answer 1

[Cris LaPierre]

Arrays and matrices can only contain data of the same data type. You need to convert all your data to the same data type before you can put it together in an array or matrix.

Why not just keep your data in a table? Since the only reason you are converting appears to be to use xlswrite, consider using writetable instead.

Answer 2

[Lei Hou]

Hi,

Please check whether table2cell meets your need.

>> t = readtable('Best NST models(1534002).xlsx');
>> table2cell(t)