def second_location_input(second_row_coordinate, second_location_list):
for i in range(len(second_row_coordinate)):
try:
worksheet.update_cell(second_row_coordinate[i], 5,
second_location_list[i])
except:
pass
def second_building_input(second_row_coordinate, second_building_list):
for i in range(len(second_row_coordinate)):
try:
worksheet.update_cell(second_row_coordinate[i], 4,
second_building_list[i])
except:
pass
def area_input(row_coordinate, area_list, number_list):
for i in range(len(row_coordinate)):
try:
worksheet.update_cell(row_coordinate[i], 3, area_list[i])
except:
print("Could not input data for number: %r" % number_list[i])
text_file = open('failed_input.txt', 'a')
text_file.write("Input data error: " + str(number_list[i]) + "\n")
def second_area_input(second_row_coordinate, second_area_list, name_list):
for i in range(len(name_list)):
try:
worksheet.update_cell(second_row_coordinate[i], 3,
second_area_list[i])
except:
print("Could not input data for name: %r" % name_list[i])
text_file = open('failed_input.txt', 'a')
text_file.write("Input data error: " + str(name_list[i]) + "\n")
def final_check(second_row_coordinate, row_coordinate, status_list):
status_list.append(second_row_coordinate + row_coordinate)
for list in status_list:
for i in range(len(list)):
worksheet.update_cell(list[i], 6, "Done")
def location_input(row_coordinate, location_list):
for i in range(len(row_coordinate)):
try:
worksheet.update_cell(row_coordinate[i], 5, location_list[i])
except:
pass
def building_input(row_coordinate, building_list):
for i in range(len(row_coordinate)):
try:
worksheet.update_cell(row_coordinate[i], 4, building_list[i])
except:
pass