MATLAB EXCEL

1 次查看（过去 30 天）
Aldin
Aldin 2011-12-16
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.

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

采纳的回答

Sean de Wolski
Sean de Wolski 2011-12-16
From:
doc xlswrite
I would actually conclude the opposite, and that it can be done easily:
MATLAB converts NaN values to empty cells
  5 个评论
显示 3更早的评论
Aldin
Aldin 2011-12-16
the cyclist is also good in answering with empty string '' ???
Aldin
Aldin 2011-12-16
for everbody her:
xlswrite('igra.xls',NaN,1,'A1');
by Aldin Habibovic helping by Sean de Wolski :)

请先登录，再进行评论。

更多回答（1 个）

the cyclist
the cyclist 2011-12-16
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 个评论
Aldin
Aldin 2011-12-16
Thanks!
empty string :) i know
Can we than conclude that there is no function in MATLAB for my question???
the cyclist
the cyclist 2011-12-16
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.

请先登录，再进行评论。

类别

在 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