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.
How to read from one column of excel (from row 40 to 80) and can match it with the other column as well?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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?
Respuesta aceptada
Pedro Villena
el 13 de Dic. de 2012
Editada: Pedro Villena
el 13 de Dic. de 2012
data = xlsread('1612_2.xls','A40:AF80');
3 comentarios
José-Luis
el 17 de Dic. de 2012
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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!