Import data from Excel

Question

Francis Chabot 2021-2-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/733118-import-data-from-excel

评论： Francis Chabot 2021-2-1

Hello,

I'm trying to input data from Excel by column and when doing it the first data which is suppose to end up in a NaN doesn't appear.

Example:

MTBV = xlsread('G-Score','Active Data','B4:B13');

When I'm inputing it the B4 data which is suppose to be a NaN is ignored by MATLAB. This problem is only with the first data because the other ones are considered as NaN when I input them.

Best regards,

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

Francis Chabot 2021-2-1

I'm getting: [2.29, 1.56, 1.87, NaN...]

Instead of getting: [NaN, 2.29, 1.56, 1.87, NaN...]

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2021-2-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/733118-import-data-from-excel#answer_611893

在 MATLAB Online 中打开

xlsread() tries to be smart. It tries its best to give you the numerical data so it truncates the leading Nan. Run this to see

[Num,Txt,Raw]=xlsread('G-Score','Active Data','B4:B13')

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

Francis Chabot 2021-2-1

When doing it, the array of doubles which countain the data still exclude the first data which should return as a NaN but all of the others NaNs are shown correctly.

I don't get why it doesn't return me a NaN for the first data.

请先登录，再进行评论。