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!