MATLAB Answers

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

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

Answers (1)

Jan
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.
  2 Comments
Jan
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: 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

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!