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

1 次查看（过去 30 天）
Ara
Ara 2012-12-13
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 个评论
Ara
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.

请先登录，再进行评论。

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

采纳的回答

Pedro Villena
Pedro Villena 2012-12-13
编辑：Pedro Villena 2012-12-13
data = xlsread('1612_2.xls','A40:AF80');
  3 个评论
显示 1更早的评论
José-Luis
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by