我编写了这个 Python 脚本来创建一个表格,其中仅包含来自我们体育俱乐部的来自全国排名的运动员。目前我必须下载排名文件,然后重新命名。#import the writerimport xlwt#import the readerimport xlrd#open the rankings spreadsheetbook = xlrd.open_workbook('rankings.xls')#open the first sheetfirst_sheet = book.sheet_by_index(0)#print the values in the second column of the first sheetprint first_sheet.col_values(1)#open the spreadsheetworkbook = xlwt.Workbook()#add a sheet named "Club BFA ranking"worksheet1 = workbook.add_sheet("Club BFA ranking")#in cell 0,0 (first cell of the first row) write "Ranking"worksheet1.write(0, 0, "Ranking")#in cell 0,1 (second cell of the first row) write "Name"worksheet1.write(0, 1, "Name") #save and create the spreadsheet fileworkbook.save("saxons.xls")name = []rank = []for i in range(first_sheet.nrows): #print(first_sheet.cell_value(i,3)) if('Saxon' in first_sheet.cell_value(i,3)): name.append(first_sheet.cell_value(i,1)) rank.append(first_sheet.cell_value(i,8)) print('a')for j in range(len(name)): worksheet1.write(j+1,0,rank[j]) worksheet1.write(j+1,1,name[j])workbook.save("saxons.xls")作为下一次迭代,我希望它转到特定的 URL 并下载最新的电子表格以用作 ratings.xls我怎样才能做到这一点?
添加回答
举报
0/150
提交
取消