MATLAB: Readtable is interpreting columns of numbers from excel wrong

cellexcelMATLABtable

I have a spreadsheet with a few colomns of numbers. MatLab seems to recognise some of these as numbers but others seem to be cells?
Springs = readtable("SpringsLS.xlsx")
An image of the output below
readtableproblem.PNG
Even when I move the colomns around and ensure formatting is the same it still makes my numbers into these, which I cant work with.
I've attached the excel doc

Best Answer

  • Which column looks wrong to you?
    I notice, for example, that the RodDiametermm columns looks like it is all numeric at the top ... but there is a cluster of non-numeric values ("in") starting at row 296 (as well as at other areas of that column).
    Ditto for HoleDiametermm.