write zero as blank

1 次查看（过去 30 天）
Neesha
Neesha 2014-12-4
编辑： Guillaume 2014-12-4
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

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2014-12-4
编辑：Guillaume 2014-12-4
c = num2cell(m);
c(m == 0) = {[]};
xlswrite('somefile.xlsx', c);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by