Importing data from excel, getting zeros

2017 11 15
1 个回答
更新时间：2017 11 15
1 次查看（30 天）

0 个投票

Hi, I am importing selected columns to Matlab from excel and all works fine except the last two rows in the column appear as 0 in Matlab. They're in the same format as the rest of the column. Has anyone had that issue? Thanks a lot.

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Walter Roberson
Walter Roberson 2017-11-15
If your file is not sensitive, could you attach a subset of it for testing?
Adam Kepinski
Adam Kepinski 2017-11-15
Hey, thanks for the answer. I've attached the file. The arrays in question are o2:o35 and P2:P35. Original file was in xslx format but I can't attach it here.
Walter Roberson
Walter Roberson 2017-11-15
Could you zip the xlsx and attach that?
Adam Kepinski
Adam Kepinski 2017-11-15
Sure. As a side note I am using a Mac
Walter Roberson
Walter Roberson 2017-11-15
Using that xlsx file I am not observing any difficulty using R2017b on Mac (El Capitan)

请先登录，再进行评论。

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

回答（1 个）

Adam Kepinski
Adam Kepinski 2017-11-15

0 个投票

I managed to run it. Restarted Matlab and copied the two col's into a different place on the spreadsheet. Still doesn't work if the columns are in the "old" place. Really bizarre.
Thanks a lot for your help!

类别

在 帮助中心 和 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