Clever Geek Handbook

Inf in Excel using Matlab xlswrite ()

I am trying to write Inf and -Inf using xlswrite in Matlab. But the value I get in xls is 65535 for both. Why is this happening?

+3


source to share


1 answer


There is a problem with the types of values ​​you want to store in a cell in Excel. First, Excel doesn't matter inf

(see here ). If you want to store a large amount, you can use for example

xlswrite('test.xls', 1e99, 1, 'A1')

however, at some point Excel just falls back to 65535

if you are using eg.



xlswrite('test.xls', 1e9999, 1, 'A1') % gives you 65535 in Excel

A quick check gives (MATLAB R2013b) that the largest number 1e308

, so

xlswrite('test.xls', 1e308, 1, 'A1')
+3


source






More articles:


All Articles