Import data from Excel

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,

[Francis Chabot]

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]

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')

[Francis Chabot]

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.