writecell( [.... -inf inf ...] gives 65535 and 65535 in Excel both for -inf and +inf

table2cell(ToperLow)

ans =

1×5 cell array

{[650]} {[-Inf]} {[-Inf]} {[-Inf]} {[500]}

>> xx = table2cell(ToperLow)

xx =

1×5 cell array

{[650]} {[-Inf]} {[-Inf]} {[-Inf]} {[500]}

writecell( xx, 'test.xls', 'Sheet', 'sheet1', 'UseExcel', false )

Resulting cells in Excel is +65535 instead of - 65535???

650 65535 65535 65535 500

[dpb]

Another of the mysteries of Excel.

It doesn't know about IEEE Inf or NaN

There are some kludges you can do like writing a VBA routine something like

Function Inf(Optional Recalc) As Double
  On Error Resume Next
  Inf = 1/0
End Function

but you have to then use conditional formatting to display the "inf" indicator for the value that is, iirc, returned as (2^1024).

All in all, use 1E99 or some other "magic number" for the purpose or just forget about it...

[Binbin Qi]

I think you can use string to instead of inf

[dpb]

For some purposes, maybe...a string in the column instead of numeric may break import and return as cellstr() though...not convenient.

Answer 1

[Maadhav Akula]

Hi,

I believe this is how Excel treats Inf and -Inf in a cell, as @Binbin Qi mentioned one workaround would be to write them as strings as mentioned in the following post:

https://www.mathworks.com/matlabcentral/answers/101501-why-does-matlab-6-5-r13-not-export-nan-or-inf-data-types-properly-when-used-as-an-activex-client

Also the documentation of xlswrite and writetable mention regarding this.

xlswrite is not recommended anymore from R2019a.

Hope this Helps!