curr_row = 29
row = worksheet.row(curr_row)
keys = [x.value for x in row]
players = {'QB': [], 'RB': [], 'WR': [], 'TE': []}
# Collect players
while curr_row < num_rows:
curr_row += 1
row = worksheet.row(curr_row)
row = dict(zip(keys, row))
if row['Pos'].value == 'PK' or row['Pos'].value == 'ST':
continue
player = league.getPlayer(row['Player'].value)
if player is None:
continue
print row
player.setStat('Pass Yds', row['Y Pa'].value)
player.setStat('Pass TD', row['TD P'].value)
player.setStat('Pass Int', row['Int'].value)
player.setStat('Rush Yards', row['Y Run'].value)
player.setStat('Rush TD', row['TD Run'].value)
player.setStat('Rec Yards', row['Y Rec'].value)
player.setStat('Rec TD', row['TD Rec'].value)
player.setStat('Ret TD', row['TD Ret'].value)
csvManager = CsvManager()
csvManager.printPlayers(league)
