extracting values from excel file

Question

Quan Seah 2018-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399843-extracting-values-from-excel-file

回答： Sharannya Ranjith 2018-5-11

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

在 MATLAB Online 中打开

Try:

num1(1:365,4)

This will give you a range rather than a single value.

Quan Seah 2018-5-9

Thank you!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sharannya Ranjith 2018-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399843-extracting-values-from-excel-file#answer_319793

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.