How could I import an excel file with NAN value into MATLAB?

[dpb]

Use readtable

Answer 1

[Anjaneyulu Bairi]

Hi,

I understand that you are trying to import an Excel file that has Nan values in it. You can use the "readtable" function to import an excel file in MATLAB, and if you have NaN as a string, then use the "TreatAsMissing" option while reading the excel file.

Here is the example :

dataTable = readtable(filename, 'TreatAsMissing', {'NaN'});

Here is the documentation link for "readtable" : https://in.mathworks.com/help/matlab/ref/readtable.html

Hop this helps.