write zero as blank

2014 12 4

1 个回答

3 次查看（30 天）

0 个投票

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Guillaume 2014-12-4

编辑：Guillaume 2014-12-4

1 个投票

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

Neesha 2014-12-4

ok, will try that, thanks !

在帮助中心和 File Exchange 中查找有关 Spreadsheets 的更多信息

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by