I wrote a code to convert the azimuth and elevation angel to latitude and longitude and plot in circle symbol. I had two problems; 1- The column of my time (time1) start from 0-24h(for one day)and I want to read it just the period time 22-10, it means I do not want to read and plot the period time between 10-22. 2- I would like someone look at my code to make me sure it's correct. When I plot different data the figures doesn't much different which is a bit weird. Could you please help me?
Happy New Year to all of you!
No products are associated with this question.
It is not possible to "not read" data unless the file is binary and the amount of space taken up by the data to be skipped can be exactly calculated.
Excel might be able to handle doing it for .xls files -- but not for .xlsx files as those are too text-oriented.
My working assumption for Excel data of modest size (as yours is) is that Excel will probably end up reading the data anyhow, and that the best you rely on is that if you know exactly which rows you want, Excel will prune back what it returns to MATLAB.
If you do not know ahead of time the exact positions of what you want Excel to read, then if you are using MS Windows, you might be able to use ActiveX to command Excel to select only the rows where a column matches particular criteria.
Play games and win prizes!Learn more