delete empty cell matlab
- by AP
I have a question :
I am generating a excel file through matlab and i have empty cells in middle of it
here is the code i am using to open a empty matrix
newfile= cell(5,5);
[newfile{:}]= deal('');
[newfile{:}]= deal(' ');
I do some processing here then i write
xlswrite ....
now i output i get is file with some empty cells and some data. IS there a command by which i can delete the empty rows, without effecting the rows which have data?
Another question :
IS there a way to append onto this excel file i am writing. I run this file everyday and would like to add aumatically rather than me manually copying and pasting everyday.
thanks