Export Excel in ruby on rails
I want to export the page Info to Excel ,who can tell me how can i 开发者_运维百科do this? thank you!
Something like this might help:
http://blog.dhavalparikh.co.in/2009/04/export-to-excel-in-ruby-on-rails/
Controller
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
<%= link_to "Export as Excel", export_person_url %>
_report.html.erb
<table border="1">
<tr>
<th>Name</th>
</tr>
<% @users.each do |u| %>
<tr>
<td><%= u.name %></td>
<% end %>
</tr>
</table>
精彩评论