# 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

# 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

  send_data csv_data,
    :type => 'text/csv; charset=iso-8859-1; header=present',
    :disposition => "attachment; filename=#{@outfile}"

  flash[:notice] = "Export complete!"
end

require 'fastercsv' # FasterCSV is not part of the Ruby Standard Library, it is a gem

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

Rails CSV Export

rails, ruby, web, csv, excel

Rails