Excel : Utilisation de l'API Google Maps
Channel: Alex NILLY
Date: 2021-03-29

Voici le code utilisé :


=SERVICEWEB("https://maps.googleapis.com/maps/api/distancematrix/xml?origins="&C2&"&destinations="&AE2&"&mode=driving&key="&$AY$2)


=FILTRE.XML(AO2; "/DistanceMatrixResponse/row/element/distance/text")

=FILTRE.XML(AO2; "/DistanceMatrixResponse/row/element/duration/text")