why xlswrite writes each letter of the string into each cell of excel?

Question

Zeynab Mousavikhamene 2020-2-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506892-why-xlswrite-writes-each-letter-of-the-string-into-each-cell-of-excel

评论： Walter Roberson 2020-2-21

I used xlswrite to write a string which is the mixture of letters and numbers into the excell cell. I want each string to be written in 1 cell but it wirtes each letters of the string to each cell.

I tried using cell arrays but it did not work.

Any suggestion?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-2-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506892-why-xlswrite-writes-each-letter-of-the-string-into-each-cell-of-excel#answer_416760

You are probably passing a character vector, which is technically an array.

Passing a cell array of character vectors will work with Windows with Excel installed. For other operating systems or if Excel cannot be reached then xlswrite requests get converted into dlmwrite requests of csv (text), and that cannot handle cell arrays.

The solution is to use writetable from r2013b, or writecell or writematrix from r2019b