How to find variable in the same Longitude and Latitude for Excel

2 次查看（过去 30 天）

Farshid Daryabor 2019-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484558-how-to-find-variable-in-the-same-longitude-and-latitude-for-excel

编辑： Michal 2019-10-11

grdc_stations.xlsx

I have a xlsx matrix size (9884*21), I'm trying to manage a matlab code to find the exact value position in the each row corresponding to the longitude and latitude, for example; And I want to save them in new file accordingly.

I appreciate any support

No. Value Lon Lat

1 a i j

2 b ii jj

3 c iii jjj

4 d . .

5 e . .

6 f . .

7 g . .

8 . . .

. . . .

9884

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

John Doe 2019-10-11

在 MATLAB Online 中打开

I have no idea what want to do. Eitherway,

You first need to import the data in MATLAB you can do this using readtable.

fullFileName = ('c:\ ..... .xslx') % Put your full file path in here.
opts.VariableNamesLine = 1;
t{1} = readtable(fullFileName, opts);

Michal 2019-10-11

编辑：Michal 2019-10-11

Are you trying to find the row number of a specific set of latitude and longitude? So, using your example table above, if your longitude is ii and latitude is jj you are hoping to get the number 2 (i.e. 2nd row; assuming we are skipping headers) so you can then extract all the information (i.e. the values of all the other columns) that can be found in that row?

请先登录，再进行评论。

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