MATLAB Answers

MLGetMatrix in Matlab2019 imports NaN values into Excel as a number

6 ビュー (過去 30 日間)
Anna
Anna 2019 年 8 月 7 日
回答済み: Akshit Agarwal 2019 年 10 月 9 日
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

  0 件のコメント

サインイン to comment.

回答 (1 件)

Akshit Agarwal
Akshit Agarwal 2019 年 10 月 9 日
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?

  0 件のコメント

サインイン to comment.

サインイン してこの質問に回答します。


Translated by