本文共 1277 字,大约阅读时间需要 4 分钟。
1. 首页要给自己的项目添加一个插件:
ruby script/plugin install http://svn.napcsweb.com/public/excel
此时项目的vender目录里有一个excel.rb,这就是我们的核心方法
2. OrderedHash这个hash是有序的,需要在控制器里面导入
require "active_support" include ActiveSupport3.看个控制器里的实例
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 0..@ala_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
转载地址:http://zdadi.baihongyu.com/