MATLAB: Write zero as blank

excelxlswrite

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

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

Hi, Just activating the particular sheet before adding range will solve it.

ex = actxserver('excel.application');

ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));

Sheets = Excel.ActiveWorkBook.Sheets;

Sheet3 = get(Sheets, 'Item', 'Sheet3');

Sheet3.Activate

ex.Range('A3').Name = 'RangeName';

ex.ActiveWorkbook.Save

ex.Quit

ex.release

maxval = max(YourVector);
NewVector = zeros(1, maxval);
NewVector(YourVector) = YourVector;