rails 导出 excel

1. 首页要给自己的项目添加一个插件：

ruby script/plugin install http://svn.napcsweb.com/public/excel

    此时项目的vender目录里有一个excel.rb,这就是我们的核心方法

2. OrderedHash这个hash是有序的，需要在控制器里面导入

require "active_support"

include ActiveSupport

3.看个控制器里的实例

def export
    @ala_users = User.find(:all)
    @count = Record.count(:conditions => [' ala_organization_id = ? and ala_user_id = ? ',session[:organization_id],session[:user_id]]) 
    @count_pass = Record.count(:conditions => [' ala_organization_id = ? and ala_user_id = ? and status = ? ',session[:organization_id],session[:user_id],'6'])        
    array = Array.new
    for i in [email protected]_users.length-1
      item = OrderedHash.new
      item["姓名"] = @ala_users[i].name
      item["部门"] = @ala_users[i].ala_department.name if @ala_users[i].ala_department
      item["职位"] = @ala_users[i].positions
      item["学时"] = @ala_users[i].learning_times
      item["学分"] = @ala_users[i].learning_credits
      item["报名课程数"] = @count[i]
      item["通过课程数"] = @count_pass[i]
      array << item
    end
    e = Excel::Workbook.new
    e.addWorksheetFromArrayOfHashes("Books info", array)
    headers['Content-Type'] = "application/vnd.ms-excel"
    headers['Content-Disposition'] = 'attachment; filename="excel-export.xls"'
    headers['Cache-Control'] = ''
    render :text=>e.build
  end