How to take a column of an excel spreadsheet and declare as a variable

I have a selection of values from a column in excel which I would like to declare as a variable in MATLAB. What would be the best way to go about doing this?

Answer 1

[Star Strider]

I would use xlsread, particularly with respect to the documentation on Read Column.

For example:

A = xlsread(filename, 'B:B');

This assigns colunm ‘B’ in the Excel file to variable ‘A’.