MATLAB Answers


How to print out tabulated data to excel

Asked by yp78
on 12 Aug 2018
Latest activity Edited by yp78
on 18 Aug 2018
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'});
% print output
fileName= 'output.xlsx';
sheetName = 'sheet1';


I think you just need to assign the output of tabulate:
C = tabulate(C);
That would overwrite the variable which is ok if that's what's wanted...
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...
Thanks for your help! It worked and I found each one of your advice helpful.

Sign in to comment.

1 Answer

Answer by KSSV
on 13 Aug 2018


Sign in to comment.