How can I import a specific matrix from an excel file using the xlsread command?

조회 수: 90 (최근 30일)
I am trying to import a 3x301 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 3x1 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.

채택된 답변

Matt Tearle
Matt Tearle 2014년 11월 6일
You need to use standard Excel indexing "topleft:bottomright":
heightdata = xlsread('Height Data.xlsx','B3:KP5');

추가 답변 (0개)


Help CenterFile 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