active_record_to_excel
active_record_to_excel is a litle tool for generate simple MS Excel reports based on the results returned from your ActiveRecord queries.
Usage
In your Gemfile:
gem 'active_record_to_excel'
Generating reports:
User.all.to_excel({ :name => 'Name', :email => 'Email' })That line of code creates a report.xls file under the public folder of your rails app.
The keys on the hash are methods of you ActiveRecord object that returns the value required, the values are the labels of the columns on the Excel sheet.
You can pass optionally two arguments: :filename and :path
User.all.to_excel({ :name => 'Name', :email => 'Email', :path => '~/reports', :filename => 'users.xls' })It will create a users.xls file in your $HOME/reports directory.
Copyleft
Copyleft (ɔ) 2011 Rubén Dávila