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

91 次查看（过去 30 天）
Erik
Erik 2014-11-6
评论： Erik 2014-11-6
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.
Thanks,
Erik

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

采纳的回答

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 Center 和 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