diff options
| author | Jonathan Tron <[email protected]> | 2014-08-01 09:51:16 +0200 |
|---|---|---|
| committer | Jonathan Tron <[email protected]> | 2014-08-01 09:51:16 +0200 |
| commit | 7cf747675097be13df633f1b2a5c45391df52b33 (patch) | |
| tree | 73a89185eb35f2fa31e5a3e206cd35a7a761fcb0 /examples | |
| parent | cd24fcfe33ad4ae2d68adf1cb598a2ede3a7dc29 (diff) | |
| download | caxlsx-7cf747675097be13df633f1b2a5c45391df52b33.tar.gz caxlsx-7cf747675097be13df633f1b2a5c45391df52b33.zip | |
Add example and test for auto filters on multiple worksheet (refs #338)
Diffstat (limited to 'examples')
| -rw-r--r-- | examples/auto_filter.rb | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/examples/auto_filter.rb b/examples/auto_filter.rb index fcfe2e90..b47082cb 100644 --- a/examples/auto_filter.rb +++ b/examples/auto_filter.rb @@ -10,7 +10,16 @@ Axlsx::Package.new do |p| 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 = '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') |