---
title: "rails 导出数据为csv格式以及编码格式的转换"
author: "PBFox"
date: "2008-10-15T15:22:00Z"
tags: []
slug: "rails-csv"
draft: false
lastmod: "2008-10-15T15:22:00Z"
id: 479223
url: "https://developerwork.iteye.com/blog/479223"
---

def convert(str)  
require 'iconv'  
begin  
converter = Iconv.new("GB2312", "UTF-8")  
converter.iconv(str)  
rescue  
str  
end  
end

def csv\_export  
@trains = TrainsUser.find(:all)

csv\_string = FasterCSV.generate do |csv|  
csv &lt;&lt; \[convert("内容名称"),convert("公司名"),convert("学习时间")]  
@trains.each do |u|  
if u.train && u.user  
csv &lt;&lt; \[convert(u.train.name),convert(u.user.company\_name),u.created\_at.strftime("%Y-%m-%d %H:%M")]  
end  
end  
end  
send\_data csv\_string,  
:type =&gt; 'text/csv; charset=utf-8; header=present',  
:disposition =&gt; "attachment; filename=#{Time.now.strftime("%Y%m%d%H%M")}\_export.csv"  
end