How to print out tabulated data to excel

3 次查看（过去 30 天）
yp78
yp78 2018-8-12
编辑： yp78 2018-8-18
Is there any way by which I can export (print) the output of tabulated data? My current code looks like this and returns an error message saying; "Error using xlswrite (line 172) input data must be a numeric, cell, or logical array".
% The "result" is N by 1 double array
C = categorical(result,[2 3 4 5 6],{'Mon','Tue','Wed','Thu','Fri'});
tabulate(C)
% print output
fileName= 'output.xlsx';
sheetName = 'sheet1';
xlswrite(fileName,C,sheetName,'B3');
  3 个评论
显示 1更早的评论
dpb
dpb 2018-8-13
That would overwrite the variable which is ok if that's what's wanted...
xlswrite(fileName,tabulate(C),sheetName,'B3');
will just output the result. Seems to work but while xlsread/write are always pretty slow, xlsread() of that particular output hung here first time and took some 30 sec to return the next. Don't know whassup w/ that...
yp78
yp78 2018-8-18
编辑：yp78 2018-8-18
Thanks for your help! It worked and I found each one of your advice helpful.

请先登录，再进行评论。

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

回答（1 个）

KSSV
KSSV 2018-8-13

类别

在 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