Status
mixture of reveling in the new stash of hoppy and fermented beverages acquired as well as how to crack open some geodatabases from
Location
Arlington, VA
Subscribe to GeoRSS Subscribe to KML

19 Aug 2006

Export to Excel

Published in Rails  |  3 Comments

Need to quickly export some data to Excel? How about doing it in just a couple of lines of code?

Excel Export Plugin is a Rails plugin to do just that.

Install the plugin:
ruby script/plugin install http://svn.napcsweb.com/public/excel

Here is an example method:


def export_project_to_excel
  e = Excel::Workbook.new
  @project = Project.find(:all)
  e.addWorksheetFromActiveRecord "Project", "project", @project
  headers['Content-Type'] = "application/vnd.ms-excel"
  render_text(e.build)
end

Similar Posts

Responses

Feed Trackback Address
  1. Brian says:

    September 7th, 2006 at 10:29 pm (#)

    Thanks for the link to my plugin! Nice site.

  2. andry says:

    May 20th, 2008 at 7:49 am (#)

    ok

  3. khim says:

    December 31st, 2008 at 4:31 am (#)

    I practiced this code with Ruby on Rails 2.9 but It doen’t work. the message show that “uninitialized constant ElectricityController::Excel ” please help me to go on solve this problem by regard….!

Leave a Response