Problem in importing data

1 次查看（过去 30 天）

显示更早的评论

Majbah 2014-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140166-problem-in-importing-data

回答： Image Analyst 2014-7-4

采纳的回答： Image Analyst

Matlab.xlsx

Hello All,

I am trying to import data from excel file to matlab. But, matlab is recognizing the numbers as NaN.

How can I solve it?

I am attaching the excel file containing all data.

Thanks, Majbah

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

Danilo NASCIMENTO 2014-7-4

Tell us the way you trying to import these data from excel to matlab, so we can help you.

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2014-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140166-problem-in-importing-data#answer_143617

At row 11919 you have a divide by zero in Excel and that's giving you a nan in the array. The rest of the array elements are the correct numbers though.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 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