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

18 visualizaciones (últimos 30 días)
Eric Penchansky
Eric Penchansky el 12 de Feb. de 2016
Respondida: Star Strider el 13 de Feb. de 2016
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?

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Star Strider
Star Strider el 13 de Feb. de 2016
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’.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by