Active Admin Axlsx: Office Open XML Spreadsheet Export for Active Admin
====================================

If you are using this for commercial purposes, or just want to show your
appreciation for the gem, please don't hesitate to make a donation.

[![Click here to lend your support to: axlsx and make a donation at www.pledgie.com !](http://www.pledgie.com/campaigns/17814.png?skin_name=chrome)](http://www.pledgie.com/campaigns/17814)

**IRC**:[irc.freenode.net / #axlsx](irc://irc.freenode.net/axlsx)

**Git**:[http://github.com/randym/activeadmin-axlsx](http://github.com/randym/activeadmin-axlsx)

**Twitter**: [https://twitter.com/#!/morgan_randy](https://twitter.com/#!/morgan_randy)

**Google Group**: [https://groups.google.com/forum/?fromgroups#!forum/axlsx](https://groups.google.com/forum/?fromgroups#!forum/axlsx)

**Author**:  Randy Morgan

**Copyright**:    2012 ~ 2013

**License**: MIT License

**Latest Version**: 2.1.1

**Ruby Version**: 1.9.2, 1.9.3

**JRuby Version**: 1.9 mode

**Rubinius Version**: rubinius 2.0.0dev * lower versions may run, this gem always tests against head.

**Release Date**: 2013.04.18

Synopsis
--------

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)

![Screen 1](https://github.com/randym/activeadmin-axlsx/raw/master/screen_capture.png)

Usage example:
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'
```

Cool Toys
---------

Here are a few quick examples of things you can easily tweak.
While Axlsx does support most anything you can do in MS Excel,
I'd be excite to implement something adventurous.
Please ping me on irc. (freenode#axlsx)

##localize column headers

```ruby
#app/admin/posts.rb
ActiveAdmin.register Post do
  config.xlsx_builder.i18n_scope [:active_record, :models, :posts]
end
```

##Use blocks for adding computed fields

```ruby
#app/admin/posts.rb
ActiveAdmin.register Post do
  config.xlsx_builder.column('author_name') do |resource|
    resource.author.name 
  end
end
```

##Change the column header style

```ruby
#app/admin/posts.rb
ActiveAdmin.register Post do
  config.xlsx_builder.header_style = { :bg_color => 'FF0000',
                                       :fg_color => 'FF' }
end
```

##Remove columns

```ruby
#app/admin/posts.rb
ActiveAdmin.register Post do
  config.xlsx_builder.delete_columns :id, :created_at, :updated_at
end
```

#Using the DSL

Everything that you do with the config'd default builder can be done via
the resource DSL. 

Below is an example of the DSL

```ruby
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

    # 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
```

#Specs
------
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 exec rake setup
```

```
bundle exec rake
```
# Changelog
**2013.04.18** Release 2.1.1
  - Serialize now returns the serialized stream instead of the Package
    object. While I doubt anyone is overriding the index wrapper on the
controller, please let me know if this breaks anything for you as it is
strictly not a backwards compatible change.
  - BugFix Package and Worksheet objects are now re-initialized on request.
  - Pre 0.5.0 conditional extension logic removed. 
**2013.03.21** Release 2.0.1
  - Fixed an issue with missing objects when using the DSL. 
    Huge thanks to [Fivell](https://github.com/Fivell)
**2012.11.29** Release 2.0.0
  - resouce content column are now pre-populated.
  - added before and after filters
  - 100% spec coverage

**2012.11.16**
  - Fixed DSL referencing
  - Added delete_columns to builder and DSL

#Copyright and License
----------

activeadmin-axlsx &copy; 2012 ~ 2013 by [Randy Morgan](mailto:digial.ipseity@gmail.com).

activeadmin-axlsx is licensed under the MIT license. Please see the LICENSE document for more information.