Reading cell array from excel table, which contains different sizes of doubles

1 次查看（过去 30 天）

显示更早的评论

Ege Arsan 2021-1-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/714328-reading-cell-array-from-excel-table-which-contains-different-sizes-of-doubles

评论： Ege Arsan 2021-1-12

采纳的回答： Adam Danz

I would like to read these columns as cell arrays, where the components are doubles, such as the following:

m_con = {[1,2,3],2,3};

I have tried xlsread but it didn't work.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Adam Danz 2021-1-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/714328-reading-cell-array-from-excel-table-which-contains-different-sizes-of-doubles#answer_595728

编辑：Adam Danz 2021-1-12

在 MATLAB Online 中打开

There might be a smoother method but this works with the data from your image.

file = 'Book1.xlsx';
opts = detectImportOptions(file);
opts = setvartype(opts, 'char');  
C = readcell(file,opts);   % you can also try readtable()
numIdx = cellfun(@isnumeric,C); 
C(numIdx) = cellfun(@num2str,C(numIdx),'UniformOutput',false);
Cnum = cellfun(@str2num,C,'UniformOutput',false)

Cnum =

3×4 cell array

{1×3 double} {1×3 double} {[ 1]} {[ 1]}

{[ 2]} {[ 2]} {1×2 double} {1×2 double}

{[ 3]} {[ 2]} {1×2 double} {1×2 double}

Cnum{1,1}

ans =

1 2 3

8 个评论
显示 6更早的评论隐藏 6更早的评论

Ege Arsan 2021-1-12

It works! Thank you so much for your help!

Ege Arsan 2021-1-12

I have one last quastion. I tried to combine these two with an if condition but i still get en error. Do you know a better expression or is it completely false waht i did?

if ~isnumeric(C)

numIdx = cellfun(@isnumeric,C);

C(numIdx) = cellfun(@num2str,C(numIdx),'UniformOutput',false);

Cnum = cellfun(@str2num,C,'UniformOutput',false);

elseif ~ischar(C)

charIdx = cellfun(@ischar,C);

Cnum(charIdx) = cellfun(@str2num,C(charIdx),'UniformOutput',false);

end

请先登录，再进行评论。