距離センサーhcsr04

#!/usr/bin/env python
# -*- coding: utf-8 -*-

def reading(sensor):
import time
import RPi.GPIO as GPIO
GPIO.setwarnings(False)

GPIO.setmode(GPIO.BOARD)
TRIG = 11
ECHO = 13

if sensor == 0:
GPIO.setup(TRIG,GPIO.OUT)
GPIO.setup(ECHO,GPIO.IN)
GPIO.output(TRIG, GPIO.LOW)
time.sleep(0.3)

GPIO.output(TRIG, True)
time.sleep(0.00001)
GPIO.output(TRIG, False)

while GPIO.input(ECHO) == 0:
signaloff = time.time()

while GPIO.input(ECHO) == 1:
signalon = time.time()

timepassed = signalon - signaloff
distance = timepassed * 17000
return distance
GPIO.cleanup()
else:
print "Incorrect usonic() function varible."

print reading(0)

#!/usr/bin/env python
# -*- coding: utf-8 -*-
#from oauth2client.service_account import ServiceAccountCredentials
import json
import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope=['https://spreadsheets.google.com/feeds']
credentials=ServiceAccountCredentials.from_json_keyfile_name('project-7766a0463656.json',scope)
gc=gspread.authorize(credentials)
wks=gc.open_by_key('1h41dJKqEmbHdZvM5zvM8MS4RJj7DxEicldyaa4ndC3E').sheet1

#各セルにアクセス
print (wks.acell('A1'))
print (wks.acell('B2'))

#書き換え
wks.update_acell('A1', u'Hello, gspread.')