How can I import excel file (.xlsx) in Matlab and store the 4th column in a vector?
7 views (last 30 days)
Show older comments
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?
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 on 1 Jul 2022
data = readmatrix(fileName); % Read entire workbook into 2-D matrix.
column4 = data(:, 4); % Extract column 4 only into column vector.
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!