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

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

Answer 1

[Cris LaPierre]

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.

Answer 2

[Image Analyst]

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