diff options
Diffstat (limited to 'examples/auto_filter.rb')
| -rw-r--r-- | examples/auto_filter.rb | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/examples/auto_filter.rb b/examples/auto_filter.rb deleted file mode 100644 index b47082cb..00000000 --- a/examples/auto_filter.rb +++ /dev/null @@ -1,25 +0,0 @@ -#!/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') |