Status

Location
London, England
Subscribe to GeoRSS Subscribe to KML


Export to Excel

Published in Rails  |  2 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

  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

Leave a Response