Contents

#!/usr/bin/env ruby -w -s
# -*- coding: utf-8 -*-

$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
require 'axlsx'
Axlsx::Package.new do |p|
  p.workbook.add_worksheet(:name => "Table") do |sheet|
    sheet.add_row ["Build Matrix"]
    sheet.add_row ["Build", "Duration", "Finished", "Rvm"]
    sheet.add_row ["19.1", "1 min 32 sec", "about 10 hours ago", "1.8.7"]
    sheet.add_row ["19.2", "1 min 28 sec", "about 10 hours ago", "1.9.2"]
    sheet.add_row ["19.3", "1 min 35 sec", "about 10 hours ago", "1.9.3"]
    sheet.auto_filter = 'A2:D5'
    sheet.auto_filter.add_column 3, :filters, :filter_items => ['1.9.2']
  end
  p.workbook.add_worksheet(:name => "Table 2") do |sheet|
    sheet.add_row ["Build Matrix"]
    sheet.add_row ["Build", "Duration", "Finished", "Rvm"]
    sheet.add_row ["19.1", "1 min 32 sec", "about 10 hours ago", "1.8.7"]
    sheet.add_row ["19.2", "1 min 28 sec", "about 10 hours ago", "1.9.2"]
    sheet.add_row ["19.3", "1 min 35 sec", "about 10 hours ago", "1.9.3"]
    sheet.auto_filter = 'A2:D5'
    sheet.auto_filter.add_column 3, :filters, :filter_items => ['1.9.2']
  end
end.serialize('auto_filter.xlsx')

Version data entries

11 entries across 11 versions & 5 rubygems

Version	Path
bonio-axlsx-2.2.3	examples/auto_filter.rb
caxlsx-3.0.2	examples/auto_filter.rb
caxlsx-3.0.1	examples/auto_filter.rb
caxlsx-3.0.0	examples/auto_filter.rb
axlsx-alt-3.0.1	examples/auto_filter.rb
axlsx-alt-3.0.0	examples/auto_filter.rb
axlsx-3.0.0.pre	examples/auto_filter.rb
bonio-axlsx-2.2.2	examples/auto_filter.rb
bonio-axlsx-2.2.1	examples/auto_filter.rb
dg-axlsx-2.1.0	examples/auto_filter.rb
axlsx-2.1.0.pre	examples/auto_filter.rb