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

12 次查看（过去 30 天）

显示更早的评论

Bella 2020-6-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/555916-how-could-i-import-an-excel-file-with-nan-value-into-matlab

编辑： Anjaneyulu Bairi 2024-1-31

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2020-6-28

Use readtable

请先登录，再进行评论。

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

回答（1 个）

Anjaneyulu Bairi 2024-1-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/555916-how-could-i-import-an-excel-file-with-nan-value-into-matlab#answer_1400481

编辑：Anjaneyulu Bairi 2024-1-31

在 MATLAB Online 中打开

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.