How to save numerical data into excel from Google maps API run in MATLAB.

15 visualizaciones (últimos 30 días)
Hi, I am running a script in the google maps API from MATLAB and receive following information. How do I save the distance and duration in an excel file?
The code is: str='https://maps.googleapis.com/maps/api/distancematrix/json?origins=nottingham&destinations=london|manchester|liverpool&key=API key';
result = urlread(str)
This is the result:
{
"destination_addresses" : [ "London, UK", "Manchester, UK", "Liverpool, Merseyside, UK" ],
"origin_addresses" : [ "Nottingham, Nottingham, UK" ],
"rows" : [
{
"elements" : [
{
"distance" : {
"text" : "205 km",
"value" : 204693
},
"duration" : {
"text" : "2 hours 43 mins",
"value" : 9809
},
"status" : "OK"
},
{
"distance" : {
"text" : "160 km",
"value" : 160238
},
"duration" : {
"text" : "2 hours 7 mins",
"value" : 7633
},
"status" : "OK"
},
{
"distance" : {
"text" : "179 km",
"value" : 179222
},
"duration" : {
"text" : "2 hours 13 mins",
"value" : 7962
},
"status" : "OK"
}
]
}
],
"status" : "OK"
  2 comentarios
Walter Roberson
Walter Roberson el 7 de En. de 2016
It looks to me as if this is missing a "}" at the end.
Kingshuk Islam
Kingshuk Islam el 13 de En. de 2016
Hello Walter,
I am not entirely sure I understand. This is the answer shown to me by matlab. I want to save the "km" and "mins" data in excel from here.

Iniciar sesión para comentar.

Respuesta aceptada

Robert Snoeberger
Robert Snoeberger el 15 de En. de 2016
Use webread instead of urlread. It will parse the JSON response for you. Then, you can gather the distance and duration data that you want and create a table. Once you have a table, you can write the table to an Excel file.
Example
>> url = ''https://maps.googleapis.com/maps/api/distancematrix/json?origins=nottingham&destinations=london|manchester|liverpool&key=API key';
>> result = webread(url);
>> % gather distance and duration data from the result and create a table
>> address = result.destination_addresses;
>> distances = [result.rows.elements.distance];
>> distance = {distances.text}';
>> durations = [result.rows.elements.duration];
>> duration = {durations.text}';
>> t = table(address, distance, duration)
t =
address distance duration
___________________________ ________ _________________
'London, UK' '205 km' '2 hours 43 mins'
'Manchester, UK' '160 km' '2 hours 7 mins'
'Liverpool, Merseyside, UK' '179 km' '2 hours 13 mins'
>>
>> % write table to Excel file
>> writetable(t, 'dist_and_dur.xls');
  5 comentarios
dimitrios chatziioannides
dimitrios chatziioannides el 22 de Feb. de 2017
if i have a lot of points (coordinates/cities) in an excel file and i want to find the distance of each other, how i suppose to do that? can you give a code for that case?
Manivannan chandrasekaran
Manivannan chandrasekaran el 30 de Dic. de 2017
Editada: Manivannan chandrasekaran el 30 de Dic. de 2017
Thanks its working
please tell me how to tabulate more than one city as origin

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by