Export data to CSV in rails [closed]

Question

I need export data as CSV in rails appl. I found this plugin: https://github.com/crafterm/comma. Do you know about some better solution?

Looks pretty comprehensive and handles data relations, I'd say stick with comma — ocodo
– ocodo, Commented Nov 29, 2010 at 8:44
Comma does not work for me in rails3. I found github.com/econsultancy/csv_builder and it works well. — boblin
– boblin, Commented Nov 29, 2010 at 10:48

pguardiario · Accepted Answer · 2012-05-16 07:04:49Z

38

If using Ruby 1.9.x, then use CSV rather than FasterCSV and stick with the default delimiters.

Controller:

respond_to do |format|
  ...           
  format.csv { render :layout => false }
end

show.csv.erb:

<%= this_is_your_view_helper_method.html_safe %>

controller_helper.rb:

require 'csv'

def this_is_your_view_helper_method
  CSV.generate do |csv| 
    Product.find(:all).each do |product|
      csv << ... add stuff here ...
    end
  end
end

edited May 16, 2012 at 7:04

pguardiario

55.2k21 gold badges130 silver badges169 bronze badges

answered Nov 29, 2010 at 11:46

hade

1,7151 gold badge16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Fletch Over a year ago

FasterCSV actually became the standard CSV library in Ruby 1.9, so no need to download it, it's already there if you're on Ruby 1.9.

David Radcliffe Over a year ago

Works great with rails 3.x too.

hade Over a year ago

Thanks @Fletch for the note! This answer has been downvoted twice and I have no idea why. If you downvote, please let me know why you're doing so.

Community · Accepted Answer · 2017-05-23 12:34:01Z

2

Checkout this Stack Overflow answer for using CSV in Ruby 1.9.x (which, as Fletch noted, includes FasterCSV but with slightly different syntax).

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered May 9, 2011 at 17:05

douglasr

1,9991 gold badge23 silver badges29 bronze badges

Collectives™ on Stack Overflow

Export data to CSV in rails [closed]

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related