xlswrite

Question

New 2011-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/4410-xlswrite

Hi,

I am trying to write a cell array (1718x142 cell) back to xls. Neither xlswrite command nor a simple manual copy paste works. I think my problem is that the cell array itself is composed of individual single cell arrays of short strings or empty cell. I would like to have an advise how to convert to a single layer cell array that I can then copy to xls.

Thank you in advance

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

请先登录，再进行评论。

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

Answer 1

Titus Edelhofer 2011-3-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/4410-xlswrite#answer_6140

If the entries in your cell array are indeed 1x1 cells of strings or empty cells, try to convert each cell entry to a string: xConverted = cellfun(@char, xOriginal, 'Uniformoutput', false);

Titus

2 个评论
显示无隐藏无

Michael Neal 2012-5-17

If I had a matrix that consisted of both strings and numbers, would I want to rewrite the numbers as strings to the matrix?

Image Analyst 2012-5-17

No, you can have both in one cell array, though you can do it that way if you want. The complication was that instead of the "string cells" in your cell array containing simple strings, they contained a cell array that contained a string. That's an extra layer of cells that you most likely don't need. Likewise, the "number cells" in your cell array should contain a number directly, not a cell that contains a number.

请先登录，再进行评论。