Need to write cell array with double and char string to excel

Question

Franco 2014-2-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/116519-need-to-write-cell-array-with-double-and-char-string-to-excel

编辑： Image Analyst 2014-2-18

I have a cell array where the first row is a string of characters identifying the information underneath and the rest of the rows are the numerical values.

A{1,:} = {'Year','Month','Day','Hour','Weekday','kW'}

A{2,:} = {2012,1,23,0.15,2,179}

Im trying to use xlswrite to write the cell array to an excel file. Turns out that Matlab doesn't like this. The error I get is "The input cell array cannot be converted to a matrix" . Anyone out there know of a work around to write my multi-type cell array to excel?

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2014-2-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/116519-need-to-write-cell-array-with-double-and-char-string-to-excel#answer_124701

在 MATLAB Online 中打开

Try this, using parentheses instead of braces:

A(1,:) = {'Year','Month','Day','Hour','Weekday','kW'}
A(2,:) = {2012,1,23,0.15,2,179}
xlswrite('text.xlsx', A);

and read this in the FAQ: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F

2 个评论
显示无隐藏无

Franco 2014-2-18

Tried that...doesnt work.

Image Analyst 2014-2-18

编辑：Image Analyst 2014-2-18

What are you expecting? I tried it and it does work . No errors at all. It puts each word into one Excel cell. The words in the top row, and the numbers into the second row. Exactly what were you hoping for?

请先登录，再进行评论。