MATLAB: How to import a specific matrix from an excel file using the xlsread command

Question

I am trying to import a 3×301 matrix from excel into matlab. The value in column A for each of the three rows is not to be imported. So I have tried:

heightdata = xlsread('Height Data.xlsx','B3:B5,B:KP')

But it returns a 3×1 matrix consisting of only the values in column B. I need to extend this matrix out using these rows through all of the values in column KP but can not seem to figure it out. I have attached the excel file.

I'm sure there is something simple I am forgetting or messing up so any help would be greatly appreciated.

Thanks,

Erik

Answer 1

You need to use standard Excel indexing "topleft:bottomright":

heightdata = xlsread('Height Data.xlsx','B3:KP5');