---
title: "ruby on rails 使用 spreadsheet-excel 把数据导入到Excel表格中并且做为邮件附件发送出去"
author: "PBFox"
date: "2007-10-26T08:42:00Z"
tags: []
slug: "ruby-on-rails-spreadsheet-excel-excel"
draft: false
lastmod: "2007-10-26T08:42:00Z"
id: 479269
url: "https://developerwork.iteye.com/blog/479269"
---

首先是安装 gem install spreadsheet-excel

其次 在script 文件夹中新建一个叫export的文件，里面代码如下：

#!/usr/bin/env ruby

require File.dirname(\_\_FILE\_\_) + '/../config/environment'  
require "spreadsheet/excel"  
include Spreadsheet  
users=User.find\_by\_sql("select count(\*) from users where created\_at &lt; '#{Time.now.strftime("%Y-%m-%d")}' and created\_at &gt; '#{1.day.ago.strftime("%Y-%m-%d")}'")

workbook = Excel.new("#{RAILS\_ROOT}/public/reports/report\_#{Time.now.strftime('%Y-%m-%d')}.xls")  
worksheet = workbook.add\_worksheet("Report of #{1.day.ago.strftime('%Y-%m-%d')}")

worksheet.write(0, 0, "#{1.day.ago.strftime('%Y-%m-%d')}")

worksheet.write(1, 0, "Daily Registered users")

worksheet.write(2, 0, "#{users\[0].count.to\_i}")

workbook.close  
第三：执行ruby script/export. 到public文件夹中看一下，是不是多了一个excel表格。

有时我们需要将导出来的表格作为邮件附件发送出去。那么我们需要在上面的代码底部，加入这段：  
Notifier.deliver\_export  
model代码如下：

class Notifier &lt; ActionMailer::Base

def export  
@recipients = "XXX@gmail.com" #收件人邮箱  
#@cc = "XXX@sina.com","XXX@163.com" #抄送人邮箱  
@subject = "#{Time.now.strftime('%Y-%m-%d')} data"  
@body = ""  
@data = ""  
File.open("#{RAILS\_ROOT}/public/reports/report\_#{Time.now.strftime('%Y-%m-%d')}.xls", "rb").each { |fp| @data&lt;&lt;fp }  
attachment :content\_type =&gt;"application/vnd.ms-excel",  
:filename =&gt; "export\_#{Time.now.strftime('%Y-%m-%d')}.xls" ,  
:body =&gt; @data  
end  
end  
这样就实现了使用spreadsheet-excel 把数据导入到Excel表格中，并且作为邮件附件发送给别人了。