How to save numerical data into excel from Google maps API run in MATLAB.
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Kingshuk Islam
el 7 de En. de 2016
Editada: Manivannan chandrasekaran
el 30 de Dic. de 2017
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
Respuesta aceptada
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
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
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
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets 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!