diff options
| author | Zsolt Kozaroczy <[email protected]> | 2020-09-11 00:36:29 +0200 |
|---|---|---|
| committer | GitHub <[email protected]> | 2020-09-11 00:36:29 +0200 |
| commit | 282eec44ef01746ee25931fa6cd287ad083fd40b (patch) | |
| tree | 14504bf429ca264812679ca971c1592853d3f762 /examples/pivot_table.rb | |
| parent | 317e8244e4d17c394c1e181f86df3974623fb865 (diff) | |
| download | caxlsx-282eec44ef01746ee25931fa6cd287ad083fd40b.tar.gz caxlsx-282eec44ef01746ee25931fa6cd287ad083fd40b.zip | |
Restructure examples folder (#47)
Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document.
The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files.
Diffstat (limited to 'examples/pivot_table.rb')
| -rw-r--r-- | examples/pivot_table.rb | 39 |
1 files changed, 0 insertions, 39 deletions
diff --git a/examples/pivot_table.rb b/examples/pivot_table.rb deleted file mode 100644 index 07d03d55..00000000 --- a/examples/pivot_table.rb +++ /dev/null @@ -1,39 +0,0 @@ -#!/usr/bin/env ruby -w -s -# -*- coding: utf-8 -*- - -$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib" -require 'axlsx' - -p = Axlsx::Package.new -wb = p.workbook - -# Create some data in a sheet -def month - %w(Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec).sample -end -def year - %w(2010 2011 2012).sample -end -def type - %w(Meat Dairy Beverages Produce).sample -end -def sales - rand(5000) -end -def region - %w(East West North South).sample -end - -wb.add_worksheet(:name => "Data Sheet") do |sheet| - sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region'] - 30.times { sheet.add_row [month, year, type, sales, region] } - sheet.add_pivot_table 'G4:L17', "A1:E31" do |pivot_table| - pivot_table.rows = ['Month', 'Year'] - pivot_table.columns = ['Type'] - pivot_table.data = ['Sales'] - pivot_table.pages = ['Region'] - end -end - -# Write the excel file -p.serialize("pivot_table.xlsx") |
