Posted By

mikegreen on 05/20/08

Tagged

rails ruby web csv excel ror spreadsheet

Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

artmotion
webstic
kukhtenko

Rails CSV Export

/ Published in: Rails

Expand | Embed | Plain Text

# require 'rubygems' if using this outside of Rails
require 'fastercsv'
 
def dump_csv
  @users = User.find(:all, :order => "lastname ASC")
  @outfile = "members_" + Time.now.strftime("%m-%d-%Y") + ".csv"
 
  csv_data = FasterCSV.generate do |csv|
    csv << [
    "Last Name",
    "First Name",
    "Username",
    "Email",
    "Company",
    "Phone",
    "Fax",
    "Address",
    "City",
    "State",
    "Zip Code"
    ]
    @users.each do |user|
      csv << [
      user.lastname,
      user.firstname,
      user.username,
      user.email,
      user.company,
      user.phone,
      user.fax,
      user.address + " " + user.cb_addresstwo,
      user.city,
      user.state,
      user.zip
      ]
    end
  end
 
  send_data csv_data,
    :type => 'text/csv; charset=iso-8859-1; header=present',
    :disposition => "attachment; filename=#{@outfile}"
 
  flash[:notice] = "Export complete!"
end

Report this snippet Tweet

Comments

Subscribe to comments

Posted By: bala on September 1, 2009

hi,

Its nice and working perfect in my rails application. But i want to change the row colour can you help?

regards k.Balasubramaniam.

Posted By: bala on September 1, 2009

hi,

Its nice and working perfect in my rails application. But i want to change the row colour can you help?

regards k.Balasubramaniam.

Posted By: victorcorey on October 15, 2010

This works great except for the flash[:notice] doesn't show until I reload the view. I am calling this from a link_to, is there a better way or am I missing something?

report controller def export_users #your code here end

view

Comment:

You need to login to post a comment.