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

조회 수: 8 (최근 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