Return the value from a specific excel colomn/row

Question

Grace Carey 2021-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/807007-return-the-value-from-a-specific-excel-colomn-row

回答： David Hill 2021-4-20

I'm trying to return the value from a specific cell from an excel spreadsheet. The user enters a latitude value and then a longitude value, and then the ambient temperature of those coords is returned. The latitude and longitude are in seperate columns. How do I find the row where both the latitude and longitude match the user's input, and then use that row number to return the temperature?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

David Hill 2021-4-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/807007-return-the-value-from-a-specific-excel-colomn-row#answer_679417

在 MATLAB Online 中打开

If you don't provide an example, we don't know what the format of lat/long/temp is in. They might be numbers or strings.

a=readmatrix('yourMatrix.xlsx');
lat=input('input latitude: ');%assuming lat is only a number not a string
long=input('input longitude: ');%assuming long is only a number not a string
temp=a(ismember(a(:,1:2),[lat,long],'rows'),3);