Writing headings AND data with the xlswrite function

1 次查看（过去 30 天）
Mauro Baldi
Mauro Baldi 2015-5-30
评论： dpb 2015-5-31
I have a cell array named NomiDopo containing the names of the columns of my Excel output file and the data (of double) stored in matrix DataSet. If I write
A = {NomiDopo; DataSet}; xlswrite('Guida_1_dopo.xlsx', A);
then the output file does not contain anything. How can I write both the name of the columns and the data in the output file at the same time? Thank you!

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

回答（1 个）

dpb
dpb 2015-5-30
Per the doc for xlswrite, the information written must be "... specified as a two-dimensional numeric or character array, or, if each cell contains a single element, a cell array. 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."
Your cell array contains an array as a cell element, not an element of the array per cell.
  2 个评论
Mauro Baldi
Mauro Baldi 2015-5-31
Thank you for your kind answer. Does this mean I have to convert the Dataset (numeric) matrix into a cell matrix and concatenate it to the heading which is already a cell array? If so, how could I convert the numeric matrix Dataset into a cell matrix? Thank you!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by