26 Dec 2014
Rails导出csv及显示中文乱码处理
导出csv如下
require 'csv' def tocsv(users) CSV.generate(:colsep => '\t', :rowsep => '\r\n') do |csv| csv << ["登录名称", "真实姓名", "组织机构"] users.each do |user| csv << [user.loginname, user.realname, user.categoriesstr] end end.encode('gb2312', :invalid => :replace, :undef => :replace, :replace => "?") end
如上代码,Excel不识别utf8的文件头,在office excel中显示中文乱码处理
encode('gb2312', :invalid => :replace, :undef => :replace, :replace => "?")
使用参考:https://ruby-china.org/topics/14306
Til next time,
Bohsu.
at 15:27