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?

2 次查看（过去 30 天）
kahhoong kok
kahhoong kok 2022-11-4
回答： Lei Hou 2022-11-18
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);

请先登录，再回答此问题。

回答（2 个）

Cris LaPierre
Cris LaPierre 2022-11-4
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.
Lei Hou
Lei Hou 2022-11-18
Hi,
Please check whether table2cell meets your need.
>> t = readtable('Best NST models(1534002).xlsx');
>> table2cell(t)

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by