write zero as blank

Hi All,

I am priniting my matrix to excel file using xlswrite. I want to write out my zero as blanks/space

how do i do it?

Thanks

Answer 1

[Guillaume]

c = num2cell(m);
c(m == 0) = {[]};
xlswrite('somefile.xlsx', c);

[Neesha]

ok, will try that, thanks !