Search code examples
ruby-on-railsruby-on-rails-3csvruby-on-rails-3.1

rails 3.1 generating CSV file

I am able to export table data to a CSV file, however there is a blank row after every record. Why and how do i fix it?

in index.html.erb

<%= link_to "Export to csv", request.parameters.merge({:format => :csv})%>

in index.csv.erb

<%- headers = ["Id", "Name"] -%>
<%= CSV.generate_line headers %>
<%- @customers.each do |n| -%>
<%- row = [ n.id, n.fname ] -%>
<%= CSV.generate_line row %>
<%- end -%>
Solution

  • This is what fixed it.

    <%= CSV.generate_line row, :row_sep => ?\t, :quote_char => ?\ %>