How can I import excel file (.xlsx) in Matlab and store the 4th column in a vector?

9 次查看（过去 30 天）
M
M 2022-6-30
回答： Image Analyst 2022-7-1
How can I import an excel file which contains 4 columns (.xlsx) in Matlab and store the 4th column in a vector?

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

回答（2 个）

Cris LaPierre
Cris LaPierre 2022-7-1
Use readtable with the following syntax to read the data into a table:
T = readtable(___,Name,Value)
To just read the 4th column, use 'Range','D:D' for the Name and Value inputs.
If your data is just numbers, you may consider using readmatrix as well, which returns an array.
A = readmatrix(___,Name,Value)
You can use the name-value input to read in a specific column.
Image Analyst
Image Analyst 2022-7-1
data = readmatrix(fileName); % Read entire workbook into 2-D matrix.
column4 = data(:, 4); % Extract column 4 only into column vector.

类别

在 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