how to read excel data
조회 수: 1 (최근 30일)
이전 댓글 표시
Hello everyone,
I want to create a function which will read data from a given excel file and will return different vectors, each corresponding to a different vector (numerical data only). Do you have any idea?
thank you
댓글 수: 0
답변 (1개)
Azzi Abdelmalek
2014년 1월 30일
To get numerical data
v=xlsread('your_file.xlsx')
댓글 수: 5
Azzi Abdelmalek
2014년 1월 30일
This doesn't make any sens, you are just replacing the function xlsread by Transformation. Just write
K=xlsread('yourfile.xls')
Then do whatever you want with the matrix K. And it's a bad idea to separate it to many vectors. If you want a third column, you can get it by
K(:,3)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!