MATLAB Answers

MATLAB xlswrite function

18 views (last 30 days)
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?

Accepted Answer

Sean de Wolski
Sean de Wolski on 28 Jan 2011
Because 2^16-1 is the largest number Excel can represent since it's 16 bit unsigned.
  2 Comments
Sean de Wolski
Sean de Wolski on 28 Jan 2011
Oops, yup.

Sign in to comment.

More Answers (2)

Kenneth Eaton
Kenneth Eaton on 28 Jan 2011
The reason? Because the documentation says so! ;)
Excerpt:
  • Excel converts Inf values to 65535. MATLAB converts NaN values to empty cells.

Stavros
Stavros on 29 Jan 2011
ty all :)

Community Treasure Hunt

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

Start Hunting!