MATLAB EXCEL

1 view (last 30 days)
Aldin
Aldin on 16 Dec 2011
Hello guys!
For example:
This code will insert my name in A1 cell in Excel:
xlswrite('test.xls',{'Aldin'},1,'A1');
Right? But what is if i will to remove my name from A1 cell. Is there a function in MATLAB for removing data from Excel? And also for updating.....
Thanks.

Accepted Answer

Sean de Wolski
Sean de Wolski on 16 Dec 2011
From:
doc xlswrite
I would actually conclude the opposite, and that it can be done easily:
MATLAB converts NaN values to empty cells
  5 Comments
Aldin
Aldin on 16 Dec 2011
for everbody her:
xlswrite('igra.xls',NaN,1,'A1');
by Aldin Habibovic helping by Sean de Wolski :)

Sign in to comment.

More Answers (1)

the cyclist
the cyclist on 16 Dec 2011
I don't know how to delete the contents, but one effective solution might be to write an empty cell:
>> xlswrite('test.xls',{''},1,'A1');
  2 Comments
the cyclist
the cyclist on 16 Dec 2011
I do not use Excel via MATLAB much, because the functionality is crippled on a Mac. I would NOT conclude that it cannot be done, just based on my one answer.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!