Import data from Excel

1 次查看（过去 30 天）
Francis Chabot
Francis Chabot 2021-2-1
评论： 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 个评论
Francis Chabot
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...]

请先登录，再进行评论。

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

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2021-2-1
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 个评论
Francis Chabot
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by