Export to Excel in Ruby on Rails

Below code will help to export the data in excel in Ruby on Rails

#Controller

1 2 3 4 5 6 7

class UserController < ApplicationController def export headers['Content-Type'] = "application/vnd.ms-excel" headers['Content-Disposition'] = 'attachment; filename="report.xls"' headers['Cache-Control'] = '' @users = User.find(:all) end

#View

export.html.erb

1
<%=link_to "Export as Excel", export_person_url %>

_report.html.erb

1
2
3
4
5
6
7
8
9
10
"1">
  
    
  
  <% @users.each do |u| %>
  
   
  <% end %>
 



Name
<%= u.name %>