MLGetMatrix in Matlab2019 imports NaN values into Excel as a number

Hi,

I am using a vba script to import a matrix from Matlab into Exel. The Matrix has NaN values in it, which previously (in Matlab2016b) have been imported as NaN into Excel. Now I switched to Matlab2019a and that same VBA code gives me a matrix in Excel where Matlab NaN values are replaced with a specific number 65535.

I've tried different spreadsheets, variables, rewrote the VBA code, etc. NaN is now always replaced with 65535 when using MLGetMatrix. How can I get it back to being imported into Excel as NaN?

Here is my sample VBA script:

Dim Err As String

Err = MLEvalString("some_code")

MatlabRequest

Application.Calculation = xlManual

MLGetMatrix "A", "some_existing_rangel"

MatlabRequest

Application.Calculation = xlAutomatic

Answer 1

[Akshit Agarwal]

Hi Anna,

Convert your NaN values to a string 'NaN' before exporting them to excel.

You may refer to a similar query that had been answered in this thread: How can I write the NaN values in the matrix to Excel using XLSWRITE?