Office Open XML Spreadsheet Export for Active Admin
The original gem is located here: https://github.com/randym/activeadmin-axlsx
This gem provides automatic OOXML (xlsx) downloads for Active Admin resources. It lets you harness the full power of Axlsx when you want to but for the most part just stays out of your way and adds a link next to the csv download for xlsx (Excel/numbers/Libre Office/Google Docs)
Simply add the following to your Gemfile and you are good to go. All resource index views will now include a link for download directly to xlsx.
gem 'activeadmin-axlsx', git: 'https://github.com/thambley/activeadmin-axlsx.git'
For Active Admin 1.0, you will also have to update config/initializers/active_admin.rb. Update the download_links setting to include xls:
config.download_links = %i[csv xml json xlsx]
Here are a few quick examples of things you can easily tweak. Axlsx supports A LOT of the specification so if you are looking to do something adventurous please ping me on irc. (freenode#axlsx)
#app/admin/posts.rb
ActiveAdmin.register Post do
config.xlsx_builder.i18n_scope = [:active_record, :models, :posts]
end
#app/admin/posts.rb
ActiveAdmin.register Post do
config.xlsx_builder.column('author_name') do |resource|
resource.author.name
end
end
#app/admin/posts.rb
ActiveAdmin.register Post do
config.xlsx_builder.header_style = { :bg_color => 'FF0000',
:fg_color => 'FF' }
end
#app/admin/posts.rb
ActiveAdmin.register Post do
config.xlsx_builder.delete_columns :id, :created_at, :updated_at
end
Everything that you do with the config'd default builder can be done via the resource DSL.
Below is an example of the DSL
ActiveAdmin.register Post do
# i18n_scope and header style are set via options
xlsx(:i18n_scope => [:active_admin, :axlsx, :post],
:header_style => {:bg_color => 'FF0000', :fg_color => 'FF' }) do
# Specify that you want to white list column output.
# whitelist
# Do not serialize the header, only output data.
# skip_header
# deleting columns from the report
delete_columns :id, :created_at, :updated_at
# adding a column to the report
column(:author) { |resource| "#{resource.author.first_name} #{resource.author.last_name}" }
# creating a chart and inserting additional data with after_filter
after_filter { |sheet|
sheet.add_row []
sheet.add_row ['Author Name', 'Number of Posts']
data = []
labels = []
User.all.each do |user|
data << user.posts.size
labels << "#{user.first_name} #{user.last_name}"
sheet.add_row [labels.last, data.last]
end
chart_color = %w(88F700 279CAC B2A200 FD66A3 F20062 C8BA2B 67E6F8 DFFDB9 FFE800 B6F0F8)
sheet.add_chart(::Axlsx::Pie3DChart, :title => "post by author") do |chart|
chart.add_series :data => data, :labels => labels, :colors => chart_color
chart.start_at 4, 0
chart.end_at 7, 20
end
}
# iserting data with before_filter
before_filter do |sheet|
sheet.add_row ['Created', Time.zone.now]
sheet.add_row []
end
end
end
Running specs for this gem requires that you construct a rails application.
To execute the specs, navigate to the gem directory, run bundle install and run these to rake tasks:
bundle install --gemfile=gemfiles/rails_42.gemfile
BUNDLE_GEMFILE=gemfiles/rails_42.gemfile bundle exec rake setup
BUNDLE_GEMFILE=gemfiles/rails_42.gemfile bundle exec rake
bundle install --gemfile=gemfiles/rails_51.gemfile
BUNDLE_GEMFILE=gemfiles/rails_51.gemfile bundle exec rake setup
BUNDLE_GEMFILE=gemfiles/rails_51.gemfile bundle exec rake
activeadmin-axlsx © 2012 ~ 2013 by Randy Morgan.
activeadmin-axlsx is licensed under the MIT license. Please see the LICENSE document for more information.