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

Question

Kingshuk Islam 2016-1-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/263019-how-to-save-numerical-data-into-excel-from-google-maps-api-run-in-matlab

编辑： Manivannan chandrasekaran 2017-12-30

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 个评论
显示无隐藏无

Walter Roberson 2016-1-7

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

Kingshuk Islam 2016-1-13

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 2016-1-15

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/263019-how-to-save-numerical-data-into-excel-from-google-maps-api-run-in-matlab#answer_206338

在 MATLAB Online 中打开

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 个评论
显示 3更早的评论隐藏 3更早的评论

dimitrios chatziioannides 2017-2-22

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 2017-12-30