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

21 次查看（过去 30 天）
Eric Penchansky
Eric Penchansky 2016-2-12
回答： Star Strider 2016-2-13
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?

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

回答（1 个）

Star Strider
Star Strider 2016-2-13
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’.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by