Export data to CSV in rails

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, Nov 29 '10 at 08:44
Comma does not work for me in rails3. I found https://github.com/econsultancy/csv_builder and it works well. — boblin, Nov 29 '10 at 10:48

score 38 · Answer 1 · edited May 16 '12 at 07:04

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 '12 at 07:04

pguardiario

53,827
19
119
159

answered Nov 29 '10 at 11:46

hade

1,715
1
16
24

10

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. – Fletch Dec 15 '10 at 14:48
1

Works great with rails 3.x too. – David Radcliffe May 09 '11 at 14:04
1

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. – hade Mar 05 '12 at 07:29

score 2 · Answer 2 · edited May 23 '17 at 12:34

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 '17 at 12:34

Community

1
1

answered May 09 '11 at 17:05

douglasr

1,894
1
23
29

Export data to CSV in rails

2 Answers2

Linked