Books for you

xls"
workbook = Excel.new(spreadsheet_file)
worksheet = workbook.add_worksheet
page_header_format = Format.new(:color=>'black', :bold=>true, :size=>30)
player_name_format = Format.new(:color=>'black', :bold=>true)
header_format = Format.new(:color=>'gray', :bold=>true)
data_format = Format.new()
workbook.add_format(page_header_format)
workbook.add_format(player_name_format)
workbook.add_format(header_format)
workbook.add_format(data_format)
worksheet.format_column(0, 35, data_format)
current_row=0
worksheet.write(current_row, 0, 'Player Win/Loss Report', page_header_format)
current_row=current_row+1
CHAPTER 4 n CREATING REPORTS ON THE DESKTOP 54
Player.find(:all).each do |player|
worksheet.format_row(current_row, current_row==1 ? 20 : 33, player_name_format)
worksheet.write(current_row, 0, player.name)
current_row=current_row+1
worksheet.write(current_row, 0, ['Game', 'Wins', 'Losses'], header_format)
current_row=current_row+1
Game.find(:all).each do |game|
win_count = Play.count(:conditions=>[
"player_id = ? AND
game_id= ? AND
won=true",
player.


Pages:
73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97