def get_Col(spreadsheetId, rangeName): service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName, majorDimension="COLUMNS").execute() google_value = result.get('values', []) # for x in google_value: # level_type.append(x[0]) # foodid列数据转化格式 return google_value
def get_tragetads(self, spreadsheetId, rangeName): foodid = [] service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() google_value = result.get('values', []) for x in google_value: foodid.append(x[0]) # foodid列数据转化格式 return foodid
def get_timeline_type(self, spreadsheetId, rangeName): level_type = [] service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() google_value = result.get('values', []) # for x in google_value: # level_type.append(x[0]) # foodid列数据转化格式 return google_value
def get_timeline_istime(self, spreadsheetId, rangeName): istime = [] service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() google_value = result.get('values', []) # print google_value for x in google_value: if x: x = 0 istime.append(x) # foodid列数据转化格式 return istime
def get_guidefood(self, spreadsheetId, rangeName, col_food): dic1 = {} service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() guide_foodvalue = result.get('values', []) for y in guide_foodvalue: if len(y) == int(col_food) + 1: dic1[y[0]] = y[int(col_food)] # print "食物id:引导id" # print dic1 return dic1
def get_food_name_map(self, spreadsheetId, rangeName): food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() food_name_map = result.get('values', []) for values in food_name_map: food_result.append(values[0]) # print (food_result) return food_result except Exception, e: raise e
def get_food_name_map(): spreadsheetId = "16zNo9Sp9c8kYu4UQLtxKhdxJqIwFMYI27n7Z4sesxew" # google后缀设计4 rangeName = "食物!B3:B47" food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() food_name_map = result.get('values', []) for values in food_name_map: food_result.append(values[0]) print (food_result) return food_result except Exception, e: raise e
def get_guidelevel(self, spreadsheetId, rangeName, col_level): guidelevel = [] guidefood = [] food = [] dic = {} service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() guide_levelvalue = result.get('values', []) for x in guide_levelvalue: if len(x) == int(col_level) + 1: dic[x[int(col_level)]] = x[0] # print "食物id:关卡id" # print dic return dic
def get_food_name_map(): spreadsheetId = "16zNo9Sp9c8kYu4UQLtxKhdxJqIwFMYI27n7Z4sesxew" # google后缀设计4 rangeName = "食物!B3:B47" food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get( spreadsheetId=spreadsheetId, range=rangeName).execute() food_name_map4 = result.get('values', []) for values in food_name_map4: food_result.append(values[0]) print(food_result) return food_result except Exception, e: raise e
def scence1(self, spreadsheetId, rangeName): food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() food_name_map4 = result.get('values', []) for x in xrange(0, len(food_name_map4[0])): num = 0 for values in food_name_map4: # print values[x] if values[x]: num = num + 1 food_result.append(num) except Exception, e: raise e
def get_timeline_name(self, spreadsheetId, rangeName): food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() google_value = result.get('values', []) for values in google_value: food_result_value = [] for foodname in values: food_result_value.append(foodname) food_result.append(food_result_value) # print (food_result[8]) return food_result except Exception, e: print (e)
def get_timeline_allfood_count(self, spreadsheetId, rangeName): allfood_arr = [] service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName, majorDimension="COLUMNS").execute() google_value = result.get('values', []) for values in google_value: food_count = 0 for foodname in values: foodname = foodname.split(",") if len(foodname) > 1: # 前两个字符没用,删了增加效率 del foodname[1] del foodname[0] # print food_count, len(foodname) food_count += len(foodname) # print food_count, foodname, len(foodname) allfood_arr.append(food_count - 1) # 去掉关卡ID return allfood_arr
def get_timeline_name(): spreadsheetId = "1mNCquKhkZtt99CfstAx0PWq27zsASlMWNLHfa0eWeP4" # map4 rangeName = "Timeline!D1:BK34" food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() google_value = result.get('values', []) for values in google_value: food_result_value = [] for foodname in values: food_result_value.append(foodname) food_result.append(food_result_value) #print (food_result[8]) return food_result except Exception, e: print (e)
def check_sum(self, spreadsheetId, rangeName): r_sum = [] service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() food_name_map4 = result.get('values', []) for values in food_name_map4: r_result = [] for n in xrange(0, len(values), 4): x = values[n] if x != '0': num = 1 else: num = 0 r_result.append(num) r_sum.append(sum(r_result)) return(r_sum)
def check_upgrade(): global slot5 dict_value = {} spreadsheet_id = slot5["slot5map1"]["spreadsheet_id"] for_range = int(slot5["slot5map1"]["for_range"]) append_range = slot5["slot5map1"]["append_range"] for i in range(1, for_range): dict_value[i] = {} range_names = [] range_names.append("upgrade!B4:B" + str(append_range)) # map1 83 range_names.append("upgrade!c4:c" + str(append_range)) # map4 93 range_names.append("upgrade!i4:I" + str(append_range)) # map2 81 range_names.append("upgrade!j4:j" + str(append_range)) # map3 90 range_names.append("upgrade!A4:A" + str(append_range)) # # range_names.append("upgrade!m4:m48") # 经验 service = google_get_credentials.get_service() re = service.spreadsheets().values().batchGet( spreadsheetId=spreadsheet_id, ranges=range_names).execute() result = re.get('valueRanges', []) for i in range(1, for_range): row_value = [] for line in result: value = line.get('values', []) # print value, len(value) row_value.append(value[i]) dict_value[i]["id"] = row_value[0] dict_value[i]["level"] = row_value[1] dict_value[i]["cash"] = row_value[2] dict_value[i]["diamond"] = row_value[3] dict_value[i]["name"] = row_value[4] # dict_value[i]["exp"] = row_value[4] return dict_value
def scence1(self, spreadsheetId, rangeName): food_result = [] try: service = google_get_credentials.get_service() result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute() food_name_map4 = result.get('values', []) # print food_name_map4 for x in xrange(0, len(food_name_map4[0])): num = 0 # print len(food_name_map4[0]) for values in food_name_map4: if(len(values) > x): # 处理越界的问题 try: if values[x]: num = num + 1 except Exception, e: print e, len(values), x, values[x] else: pass food_result.append(num) # print len(values), x, num, len(food_result), values[x] except Exception, e: # raise e print e