transmit a Excel file in a vector or matrix
조회 수: 3 (최근 30일)
이전 댓글 표시
Hi,
i'm searching for information to transmit a Excel file in a vector or matrix.
Thanks
답변 (1개)
BN
2020년 1월 21일
편집: BN
2020년 1월 21일
I think you want to import an excel file into Matlab.
You can use xlsread if your excel format is .xls
myfile = xlsread('filename.xlsx') %or xls (it depends on format of your excel file)
or csvread if your excel file is .csv
myfile = csvread('filename.csv')
Alternatively, I recommend you to import your excel file using one of these commands:
myfile = readtable('filename.xlsx') %or filename.csv or filename.xls
you can read your excel file as a matrix:
A = readmatrix('filename.xlsx')
Or even read it as cell structure:
C = readcell('filename.xlsx')
once data is read into the workspace using any of the above-mentioned commands, you can do whatever you want.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!