gem 'excel_rails' # excel_rails need this
gem 'spreadsheet'

class RemitNotificationsController < ApplicationController

  def index
    @search = RemitNotification.valid.order("id DESC").search(params[:search])
    @remit_notifications = @search.paginate :per_page => 20, :page => params[:page]
    respond_to do |format|
      format.html # index.html.erb
      format.xml { render :xml => @remit_notifications }
      format.xls
    end
  end

end

excel_document(:filename => "all_lines.xls") do |workbook|
sheet = workbook.create_worksheet
sheet.name = "What's in a name"

sheet.row(0).concat %w{汇款告知}

# sheet[1,0] = 'Japan'

# row = sheet.row(1)

# row.push 'Creator of Ruby'

# row.push 'Creator of rails'

# row.unshift 'Yukihiro Matsumoto'

# sheet.row(5).unshift 'HaHa'

# sheet.row(3).push 'Charles Lowe', 'Author of the ruby-ole Library'

# sheet.row(3).insert 1, 'Unknown'

# sheet.update_row 4, 'Hannes Wyss', 'Switzerland', 'Author'

sheet.row(1).replace [ '流水号', '客户名称','客户号','金额','通过认证时间','不通过时间','创建时间' ]

sheet.row(0).height = 18
sheet.row(0).height = 18

format = Spreadsheet::Format.new :color => :blue,:weight => :bold,:size => 18

sheet.row(0).default_format = format

# 设置表格的标题栏为粗体

bold = Spreadsheet::Format.new :weight => :bold,:horizontal_align => :center
7.times do |x| sheet.row(1).set_format(x, bold) end
  @remit_notifications.each_with_index do |remite,index|
    sheet.row(index + 2).push remite.id,remite.user_name,remite.user_id,remite.money,date_format(remite.verified_at),date_format(remite.refused_at),date_format(remite.created_at)
  end
end