How to write a cell array of numbers and string to file

What is the easiest way to dump a cell array to a file.

Answer 1

[Fangjun Jiang]

xlswrite('test.xls',{'abc',1;2,'adsjk'});

[Walter Roberson]

Sounds good, provided no string is more than 191 characters and the number of rows and columns do not exceed the limits of Excel. Note also this will only work on MS Windows and only if Excel is installed (it will not work on Mac even if Excel is installed there.)

A point to note for future reference: xlswrite() cannot write if there are nested cell arrays. And don't even _think_ about writing objects.

[Fangjun Jiang]

Probably a typo. The limit on the number of characters allowed in a cell when using xlswrite() is 911, not 191.

[Walter Roberson]

Thanks, Fangjun.