table to excel code update

1 次查看（过去 30 天）

hussain abdelaziz 2021-7-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/881173-table-to-excel-code-update

评论： hussain abdelaziz 2021-7-23

in matlab 2020 my code was working very good when i update to 2021 my code didn't work any more and it says Error using cellfun

Input #2 expected to be a cell array, was struct instead.

my code was i don't know what is change in matlab 2021a ? and how to correct it

to convert table with struct to excel sheet

if true
  n = cellfun(@length,result.bw);
  f = repelem(result.fileName,n);
  s = vertcat(result.bw{:});
  s = struct2table(s);
  s.fileName = f;
  writetable(s,'myexcel.xlsx');
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2021-7-18

https://www.mathworks.com/matlabcentral/answers/795837-how-to-convert-table-with-struct-to-excel-sheet?s_tid=srchtitle appears to be relevant.

So whatever was storing cell array of struct array into the table object is storing something else instead. We would need the code that is creating the bw variable in the table object.

hussain abdelaziz 2021-7-23