Skip to content

Instantly share code, notes, and snippets.

@aabhassenapati
Created November 20, 2019 02:21
Show Gist options
  • Save aabhassenapati/1c6a9331bfba85aff4915ab6fbd1d49d to your computer and use it in GitHub Desktop.
Save aabhassenapati/1c6a9331bfba85aff4915ab6fbd1d49d to your computer and use it in GitHub Desktop.
Smart Security Camera Project
from __future__ import print_function
from xlrd import open_workbook
from googleapiclient.discovery import build
from httplib2 import Http
from oauth2client import file, client, tools
from oauth2client.service_account import ServiceAccountCredentials
import xlrd
import time
import datetime
import cv2
import xlwt
MY_SPREADSHEET_ID = '12EC6AmdEUOcwQgLIDZ64rMbR9pDLmvMdb6gjcN0w5mY'
def update_sheet(sheetname, name , time):
"""update_sheet method:
appends a row of a sheet in the spreadsheet with the
the latest temperature, pressure and humidity sensor data
"""
# authentication, authorization step
SCOPES = 'https://www.googleapis.com/auth/spreadsheets'
creds = ServiceAccountCredentials.from_json_keyfile_name(
'client_secret.json', SCOPES)
service = build('sheets', 'v4', http=creds.authorize(Http()))
# Call the Sheets API, append the next row of sensor data
# values is the array of rows we are updating, its a single row
values = [ [ time,
'Person', name] ]
body = { 'values': values }
# call the append API to perform the operation
result = service.spreadsheets().values().append(
spreadsheetId=MY_SPREADSHEET_ID,
range='Sheet1' + '!A1:C1',
valueInputOption='USER_ENTERED',
insertDataOption='INSERT_ROWS',
body=body).execute()
row=2
count = 2
while True:
# A3 to D7
workbook = xlrd.open_workbook(r"book2.xls")
sheet = workbook.sheet_by_index(0)
m = str(sheet.cell(1,2))
o =int( float (m[7:]))
n=o+2
print(n)
if(count<n):
data = str(sheet.cell(row,0))
time = str(sheet.cell(row,1))
print(count)
update_sheet("Face_Recognition" , data[5:] , time[5:])
count=count+1
row = row + 1
#print (count)
@Quinabovered
Copy link

It is indeed true that technology has evolved so much in today's world that whether you are a private home owner or a commercial business owner, you should feel confident that your front entrance is secure. As a result, many individuals prefer smarthome front door security systems. These systems may include features such as home intercom or business speakers, and they can give you peace of mind by ensuring the security of your front door.

@Enambriat1996
Copy link

HI

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment