MATLAB Answers

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

1 view (last 30 days)
mat on 11 Jul 2013
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,

Answers (1)

Jan on 11 Jul 2013
You cannot store a matrix in one cell of an Excel table. Excel table cells contain nothing, one number, a string or a macro.
Jan on 11 Jul 2013
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: This might be useful:

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!