MLGetMatrix in Matlab2019 imports NaN values into Excel as a number
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
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 个评论
另请参阅
类别
在 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!