How to i refer to columns and rows from my imported data?

I imported data from Exel into matlab. I didn't import the headings of each row however I noticed it automatically named the columns by their header in the workspace section. I have a 25 by 400 data set with a range of numerical and categorical information. The file is save as mortgagedata.xls. How do I refer to this in my script?

I tried: x=mortgagedata(:,[1:25]);

but it is saying it is says: Undefined function or variable 'mortgagedata'.

How do I get it to refer to them?

[Joshua]

Generally when you import data into Matlab the data will show up in the workspace on the side of the Matlab window. See what it named the vectors or matrices that it imported and use those names. Alternatively, try something like this and refer to matrix A:

A=importdata('mortgagedata.xlsx');

Answer 1

[KSSV]

Use xlsread.

[num,txt,raw] = xlsread(' mortgagedata.xls') ;

All the text data, number data will be read. Read the documentation xlsread.