xlswrite - how does one write a multi-size cell in 'one go'?

Question

mat 2013-7-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/81747-xlswrite-how-does-one-write-a-multi-size-cell-in-one-go

hi

this is a quote from the help section on xlswrite:

'If A is a cell array containing something other than a scalar numeric or a string, then xlswrite silently leaves the corresponding cell in the spreadsheet empty.'

how can one fill in this empty cell with a data matrix ?

thanks a lot,

mat

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

请先登录，再进行评论。

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

Answer 1

Jan 2013-7-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/81747-xlswrite-how-does-one-write-a-multi-size-cell-in-one-go#answer_91460

You cannot store a matrix in one cell of an Excel table. Excel table cells contain nothing, one number, a string or a macro.

2 个评论
显示无隐藏无

mat 2013-7-11

hi jan,

thanks!

this is precisely my question. can i somehow store an nxm matrix AND an adjacent MxN matrix in one xlswrite command?...

thanks again,

mat

Jan 2013-7-11

It depends on what you define as "one xlswrite command" and what the intention of this limitation is. There are a lot of submissions in the FEX about the communuication with Excel, so it is a good idea to search there: http://www.mathworks.com/matlabcentral/fileexchange/index?utf8=%E2%9C%93&term=xlswrite. This might be useful: http://www.mathworks.com/matlabcentral/fileexchange/22365-function-for-faster-data-transfer-matlab-%3C-%3E-excel

请先登录，再进行评论。

xlswrite - how does one write a multi-size cell in 'one go'?

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

回答（1 个）

2 个评论
显示无隐藏无

另请参阅

类别

标签

Community Treasure Hunt

xlswrite - how does one write a multi-size cell in 'one go'?

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

回答（1 个）

2 个评论 显示 无隐藏 无

另请参阅

类别

标签

Community Treasure Hunt

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

2 个评论
显示无隐藏无