Das deutsche Python-Forum

Code: Alles auswählen

import os
import openpyxl
import googlemaps
import requests
import json

key = 'AIzaSyBT1kaERkXXXXXXXXXXXXA'

os.chdir('E:\\Entfernung')
print (os.getcwd())

wb = openpyxl.load_workbook('Entfernung.xlsx')
sheet = wb['Tabelle1']

for row in range (1,90):
    celldestination = 'd' + str(row)
    strasse = (sheet[celldestination].value)
    gmaps = googlemaps.Client(key)
    destination = strasse
    url = 'https://maps.googleapis.com/maps/api/distancematrix/json?units=metric&origins=Beispielstrasse+115,+Berlin&destinations=%s, Berlin &key=%s' % (destination,key)
    r = requests.get(url)
    entfernung = json.loads(r.text)
    km = entfernung['rows'][0]['elements'][0]['distance']['text']
    celldistance = 'f' + str(row)
    sheet[celldistance] = km
    wb.save('test.xlsx')

Code: Alles auswählen

import openpyxl
import requests

KEY = 'AIzaSyBT1kaERknFXD6gRSXXXXX
ZAEHLER = 1

wb = openpyxl.load_workbook('Entfernung.xlsx')
sheet = wb['Tabelle1']

for cell in sheet['D']:
    street = (cell.value)
    payload = {'units' : 'metric', 'destinations' : street + 'Berlin', 'origins' : 'Musterstr+115,+Berlin', 'key': KEY}
    r = requests.get('https://maps.googleapis.com/maps/api/distancematrix/json', params=payload)
    antwort = r.json()
    entfernung = antwort['rows'][0]['elements'][0]['distance']['text']
    sheet['F'+ str(ZAEHLER)] = entfernung
    ZAEHLER = ZAEHLER + 1

wb.save('test.xlsx')

Code: Alles auswählen

import openpyxl
import requests

KEY = 'AIzaSyBT1kaERknFXD6gRSXXXXX'
DISTANCE_URL = 'https://maps.googleapis.com/maps/api/distancematrix/json'
DISTANCE_PARAMS = {
    'units': 'metric',
    'origins': 'Musterstr. 115, Berlin',
    'key': KEY,
}

wb = openpyxl.load_workbook('Entfernung.xlsx')
sheet = wb['Tabelle1']

for row, cell in enumerate(sheet['D']):
    street = cell.value
    payload = dict(DISTANCE_PARAMS, destinations=f"{street}, Berlin")
    response = requests.get(DISTANCE_URL, params=payload)
    antwort = response.json()
    entfernung = antwort['rows'][0]['elements'][0]['distance']['text']
    sheet[f"F{row}"] = entfernung

wb.save('test.xlsx')

Code: Alles auswählen

Traceback (most recent call last):
  File "..\PyCharmCE2019.3/config/scratches/scratch_2.py", line 22, in <module>
    sheet[f"F{row}"] = entfernung
  File "..\PycharmProjects\MyProject\venv\lib\site-packages\openpyxl\worksheet\worksheet.py", line 309, in __setitem__
    self[key].value = value
AttributeError: 'tuple' object has no attribute 'value'