Save an output file which is a cell

Question

Lavanya S 2018-10-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/423503-save-an-output-file-which-is-a-cell

回答： OCDER 2018-10-11

How to write a cell to excel sheet (or in any format). The cell contains strings as well as doubles. Thanks in advance

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

请先登录，再进行评论。

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

Answer 1

OCDER 2018-10-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/423503-save-an-output-file-which-is-a-cell#answer_340943

在 MATLAB Online 中打开

Data = {'string', 1, [1 2 3 4]};
%Make sure there is no multi-element entity in each cell (like the matrix)
MatLoc = cellfun(@(x) isnumeric(x) && numel(x) > 1, Data);
Data(MatLoc) = cellfun(@mat2str, Data(MatLoc), 'un', 0);
xlswrite('MyFile.xlsx', Data); 
%OR  
writetable(cell2table(Data), 'MyFile2.xlsx'); %Use (..., 'WriteVariableNames', 0) inputs if 
                                              %you don't want "Data1, Data2, Data3" as the first row