@@ -92,10 +92,15 @@ 'color': '#0070C0'}) total_style = wb.add_format({'font_name': 'Milk Mustache BB', 'font_size': 14, 'align': 'center', 'bold': 'true'}) + prizename_style = wb.add_format({'font_name': 'Milk Mustache BB', + 'font_size': 14}) + prizewinner_style = wb.add_format({'font_name': 'Back Issues BB', + 'font_size': 12, + 'color': '#E26B0A'}) style['player_title'] = wb.add_format({'font_name': 'Back Issues BB', 'font_size': 28, 'bold': True, 'color': '#0096FF'}) @@ -184,11 +189,15 @@ excel_score_sheet(wb, style, player, title) end_row = 3 + len(g.players) ws.write(end_row + 1, 0, "Prizes", title_style) - + prizelist = g.prizes() + + for n, (prizename, winners) in enumerate(prizelist.items()): + ws.write(end_row + 2 + n, 0, prizename, prizename_style) + ws.write(end_row + 2 + n, 1, winners, prizewinner_style) wb.close() def excel_score_sheet(workbook, styles, player, title): ws = workbook.add_worksheet(player.name)