How to print out tabulated data to excel

Question

yp78 2018-8-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/414587-how-to-print-out-tabulated-data-to-excel

编辑： 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更早的评论隐藏 1更早的评论

dpb 2018-8-13

在 MATLAB Online 中打开

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 2018-8-18