MATLAB xlswrite function

4 次查看（过去 30 天）
Stavros
Stavros 2011-1-28
Hello all MATLAB users:
This came to my attention,
>> x = [inf 3 4 inf];
>> xlswrite('test',x,'test');
if you open the .xls file you will notice that the inf value in xls is the "magic" number 65535.
Does anyone know the reason?

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

采纳的回答

Sean de Wolski
Sean de Wolski 2011-1-28
Because 2^16-1 is the largest number Excel can represent since it's 16 bit unsigned.
  2 个评论
Kenneth Eaton
Kenneth Eaton 2011-1-28
Don't you mean unsigned 16 bit? ;)

请先登录，再进行评论。

更多回答（2 个）

Kenneth Eaton
Kenneth Eaton 2011-1-28
The reason? Because the documentation says so! ;)
Excerpt:
  • Excel converts Inf values to 65535. MATLAB converts NaN values to empty cells.
Stavros
Stavros 2011-1-29
ty all :)

类别

在 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