Character encoding issue exporting rails data to CSV

by

When Excel opens the CSV file it just assumes an “iso-8859-1” character encoding. I guess it doesn’t even know about the encoding information you send along within your HTTP reply. That’s why setting this to UTF-8 doesn’t work.

So in order to export your CSV file for Excel in Rails you could do this:

send_data Iconv.conv('iso-8859-1//IGNORE', 'utf-8', csv_data),
  :type => 'text/csv; charset=iso-8859-1; header=present',
  :disposition => "attachment; filename=#{filename}.csv"

This re-encodes your UTF-8 data string (that’s the Rails default) to ISO-8859 and sends it. Along goes the information that this reply is actually ISO-8859-1 encoded (which won’t make a difference for Excel but is technically correct if you should open it in a browser etc.).

More Related Contents:

  1. rails error, couldn’t parse YAML
  2. Share database between 2 apps in Heroku
  3. Understanding :source option of has_one/has_many through of Rails
  4. Implement “Add to favorites” in Rails 3 & 4
  5. How to empty a Heroku database
  6. Turn off CSRF token in rails 3
  7. Stubbing authentication in request spec
  8. Rails’ link_to method: GETing when it should DELETE
  9. Rails 3.1: Engine vs. Mountable App
  10. rails – “WARNING: Can’t verify CSRF token authenticity” for json devise requests
  11. Disable HTML escaping in erb templates
  12. Separate REST JSON API server and client? [closed]
  13. Adding a column to an existing table in a Rails migration
  14. “Who’s Online” using Devise in Rails
  15. default_url_options and rails 3
  16. rmagick gem install “Can’t find Magick-config”
  17. Rails Engine – Gems dependencies, how to load them into the application?
  18. Rails 3 library not loading until require
  19. Clarification on how to use “thumbs_up” voting gem with Rails 3
  20. Rails 3.1 asset pipeline and manually ordered Javascript requires
  21. Rails 3 paperclip vs carrierwave vs dragonfly vs attachment_fu [closed]
  22. How can I specify a gem to pull from a private github repository?
  23. HABTM Polymorphic Relationship
  24. Rails 3 render action from another controller
  25. rails 3 activerecord order – what is the proper sql injection work around?
  26. Error “…cannot load such file — mysql2/2.0/mysql2 (LoadError)”. On Windows XP with Ruby 2.0.0
  27. Setting up a polymorphic has_many :through relationship
  28. rails:3 Devise signup Filter chain halted as :require_no_authentication rendered or redirected
  29. Does accepts_nested_attributes_for work with belongs_to?
  30. Default_url in Paperclip Broke with Asset Pipeline Upgrade

Leave a Comment