How to print out tabulated data to excel

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');

[Paolo]

I think you just need to assign the output of tabulate:

 C = tabulate(C);

[dpb]

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]

Thanks for your help! It worked and I found each one of your advice helpful.

Answer 1

[KSSV]

Read about writetable

https://in.mathworks.com/help/matlab/ref/writetable.html