extracting values from excel file
조회 수: 1 (최근 30일)
이전 댓글 표시
So I have read an excel file from a set data by using xlsread(), and now I want to get information from the excel file that is 9354x4. And I am trying to get all the data from row 1 to row 365 that is in the fourth column, I have tried using num1(365,4)*Note num1 is the variable that I used to read the excel file*, and it only gives me the data that belongs to row 365 column 4, but what I want is everything starts from row 1 to row 365 that is in column 4, please help.
댓글 수: 2
Pawel Jastrzebski
2018년 5월 9일
편집: Pawel Jastrzebski
2018년 5월 9일
Try:
num1(1:365,4)
This will give you a range rather than a single value.
답변 (1개)
Sharannya Ranjith
2018년 5월 11일
As suggested by Pawel, use a colon as a subscript. num1(1:365,4) should do the trick. Refer https://www.mathworks.com/help/matlab/ref/colon.html for more information on other indexing expressions.
댓글 수: 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!