def get_users():
book = open_workbook("surf_users.xls")
sheet = book.sheet_by_index(0)
for i in range(0, sheet.nrows):
contact = str(sheet.cell(i, 0).value)
spot_list = []
for j in range(1, sheet.ncols):
if sheet.cell(i, j).value != "":
spot_list.append(ast.literal_eval(sheet.cell(i, j).value))
find_surf_at_spot(contact, spot_list)
def get_users():
book = open_workbook("surf_users.xls")
sheet = book.sheet_by_index(0)
for i in range(0, sheet.nrows):
contact = str(sheet.cell(i, 0).value)
spot_list = []
for j in range(1, sheet.ncols):
if sheet.cell(i, j).value != "":
spot_list.append(ast.literal_eval(sheet.cell(i, j).value))
find_surf_at_spot(contact, spot_list)
def one_user(number, distance=10, start_distance=0):
book = open_workbook("surf_users.xls")
sheet = book.sheet_by_index(0)
i = 0
spot_list = []
for el in range(0, sheet.nrows):
if sheet.cell(el, 0).value == number:
break
else:
i += 1
if i == sheet.nrows:
msg = "Sorry, but it seems that you do not have any surf spots stored."
server = smtplib.SMTP("smtp.gmail.com", 587)
server.starttls()
server.login("*****@*****.**", "password")
server.sendmail("SurfNotification", number, msg)
return
for j in range(1, sheet.ncols):
if sheet.cell(i, j).value != "":
spot_list.append(ast.literal_eval(sheet.cell(i, j).value))
if len(spot_list) > 0:
find_surf_at_spot(number, spot_list, distance, start_distance)
def one_user(number, distance=10, start_distance=0):
book = open_workbook("surf_users.xls")
sheet = book.sheet_by_index(0)
i = 0
spot_list = []
for el in range(0, sheet.nrows):
if sheet.cell(el, 0).value == number:
break
else:
i += 1
if i == sheet.nrows:
msg = "Sorry, but it seems that you do not have any surf spots stored."
server = smtplib.SMTP("smtp.gmail.com", 587)
server.starttls()
server.login("*****@*****.**", "password")
server.sendmail("SurfNotification", number, msg)
return
for j in range(1, sheet.ncols):
if sheet.cell(i, j).value != "":
spot_list.append(ast.literal_eval(sheet.cell(i, j).value))
if len(spot_list) > 0:
find_surf_at_spot(number, spot_list, distance, start_distance)
