summaryrefslogtreecommitdiffhomepage
path: root/examples/pivot_table.rb
diff options
context:
space:
mode:
authorZsolt Kozaroczy <[email protected]>2020-09-11 00:36:29 +0200
committerGitHub <[email protected]>2020-09-11 00:36:29 +0200
commit282eec44ef01746ee25931fa6cd287ad083fd40b (patch)
tree14504bf429ca264812679ca971c1592853d3f762 /examples/pivot_table.rb
parent317e8244e4d17c394c1e181f86df3974623fb865 (diff)
downloadcaxlsx-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.rb39
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")