Export Excel in ruby on rails

Question

I want to export the page Info to Excel ,who can tell me how can i do this? thank you!

For what it's worth, I checked out a few options to do exactly this and wound up using the spreadsheet gem (rubygems.org/gems/spreadsheet). The documentation is a bit meh, but it is quite powerful and I was able to extend it to fit my needs. — Joshua Pinter
– Joshua Pinter, Commented Apr 17, 2011 at 21:02
please google next time first (e.g 'rails export to excel' gives You same pages as people put for You in the comment section ;) ) — lukaszkups
– lukaszkups, Commented Jun 12, 2012 at 14:37

brendan · Accepted Answer · 2010-04-29 01:57:26Z

9

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>

answered Apr 29, 2010 at 1:57

brendan

30.1k20 gold badges70 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Small Wolf Over a year ago

thank you for you help! now i use the spreadsheet plugin to solve the problem

Collectives™ on Stack Overflow

Export Excel in ruby on rails

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related