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

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"

[Walter Roberson]

It looks to me as if this is missing a "}" at the end.

[Kingshuk Islam]

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.

Answer 1

[Robert Snoeberger]

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');

[Kingshuk Islam]

Dear Robert, thank you so much. That works perfectly. Can you also please guide me to save this data in excel so that I can do some arithmetic operations on them. These are being saved as text and cannot be added or subtracted later.

[Robert Snoeberger]

You should use the field "value" instead of "text". In the example, change " distance = {distances.text}';" to " distance = {distances.value}';". Do the same for duration.

[Kingshuk Islam]

Thanks. That works perfectly.

[dimitrios chatziioannides]

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]

Thanks its working

please tell me how to tabulate more than one city as origin