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

1 view (last 30 days)
M
M on 30 Jun 2022
Answered: Image Analyst on 1 Jul 2022
How can I import an excel file which contains 4 columns (.xlsx) in Matlab and store the 4th column in a vector?

Answers (2)

Cris LaPierre
Cris LaPierre on 1 Jul 2022
Use readtable with the following syntax to read the data into a table:
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.
You can use the name-value input to read in a specific column.

Image Analyst
Image Analyst on 1 Jul 2022
data = readmatrix(fileName); % Read entire workbook into 2-D matrix.
column4 = data(:, 4); % Extract column 4 only into column vector.

Community Treasure Hunt

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

Start Hunting!

Translated by