How to read from one column of excel (from row 40 to 80) and can match it with the other column as well?

Question

Ara 2012-12-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56508-how-to-read-from-one-column-of-excel-from-row-40-to-80-and-can-match-it-with-the-other-column-as-w

Hi Guys, I am trying to show five satellites in one plot.I have one excel file with 32 column and one of the column is related to time so I need to plot it in a specific time for ex, (5-10)ut. The problem is can not match the dimension of the rest matrix.

data=xlsread('1612_2.xls');

data_filterr=find(data(:,25)>60);

data_filtered=data(data_filterr,:);

elev_cutof20=find(data_filtered(:,6)>30);

data_cutoff15=data_filtered(elev_cutof20,:);

r=data_cutoff15(:,2);

time=(r./3600)-24*2;

s4r=data_cutoff15(:,8);

s4cor=data_cutoff15(:,9);

s4=sqrt(s4r.^2-s4cor.^2);

PRN=data_cutoff15(:,3);

I want to plot each PRN different color(satellite)in a certain time in a one figure. Could be for example, 5 PRN at that time.

Could you please help me?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ara 2012-12-13

Thank you, just one more thing. I really do not know from each row start the time for ex, 5ut so all I want to do is choose from time column those data are between 5-10 and then sort the rest of data as well.

请先登录，再进行评论。

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

Answer 1

Pedro Villena 2012-12-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56508-how-to-read-from-one-column-of-excel-from-row-40-to-80-and-can-match-it-with-the-other-column-as-w#answer_68409

编辑：Pedro Villena 2012-12-13

在 MATLAB Online 中打开

data = xlsread('1612_2.xls','A40:AF80');

3 个评论
显示 1更早的评论隐藏 1更早的评论

José-Luis 2012-12-17

Read the entire range and select only the data you want afterwards. Alternatively, read twice, specifying a different range every time. Personally, I would go with the first option. Or you could use the activeX server, but for just one file and so little data, it's probably overkill.

Ara 2012-12-19