MLGetMatrix in Matlab2019 imports NaN values into Excel as a number

3 次查看（过去 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

请先登录，再回答此问题。

回答（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?

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by