render csv sample action

export_to_csv.rb

def export_to_csv 
  @users = User.find(:all) 
  csv_string = CSV.generate do |csv| 
    # header row 
    csv << ["id", "first_name", "last_name"] 
 
    # data rows 
    @users.each do |user| 
      csv << [user.id, user.first_name, user.last_name] 
    end 
  end 
 
  # send it to the browsah
  send_data csv_string, 
            :type => 'text/csv; charset=iso-8859-1; header=present', 
            :disposition => "attachment; filename=users.csv" 
end

render_csv.template.rb

def render_csv
      compile_data
      out = [["Korean Name", "English Name", "User ID", "Cohort Name", "Teacher", "Attended Count", "Absent Coun", "Total", "Attended Rate"].join(",")]
      @results.each{|r| out << r.join(",")}
      out = out.join("\n\r")
      filename = resource.course.name + params[:starting] + "-" + params[:ending] + ".csv"
      headers["Content-Type"] = 'text/csv; charset=UTF-8'
      headers["Content-Disposition"] = "attachment; filename=\"#{filename}\""
      render :text => out
end