Importing data from excel, getting zeros

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.

[Walter Roberson]

If your file is not sensitive, could you attach a subset of it for testing?

[Adam Kepinski]

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]

Could you zip the xlsx and attach that?

[Adam Kepinski]

Sure. As a side note I am using a Mac

[Walter Roberson]

Using that xlsx file I am not observing any difficulty using R2017b on Mac (El Capitan)

Answer 1

[Adam Kepinski]

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!