From 282eec44ef01746ee25931fa6cd287ad083fd40b Mon Sep 17 00:00:00 2001
From: Zsolt Kozaroczy <kiskoza@gmail.com>
Date: Fri, 11 Sep 2020 00:36:29 +0200
Subject: 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.
---
 examples/pivot_table_example.md | 40 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 examples/pivot_table_example.md

(limited to 'examples/pivot_table_example.md')

diff --git a/examples/pivot_table_example.md b/examples/pivot_table_example.md
new file mode 100644
index 00000000..21176a73
--- /dev/null
+++ b/examples/pivot_table_example.md
@@ -0,0 +1,40 @@
+## Description
+
+Pivot tables are cool.
+
+## Code
+
+```ruby
+require 'axlsx'
+
+p = Axlsx::Package.new
+wb = p.workbook
+
+wb.add_worksheet(name: 'Basic Worksheet') do |sheet|
+  sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region']
+
+  # Generate some data
+  30.times do
+    sheet.add_row [
+      ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'].sample,
+      [2010, 2011, 2012].sample,
+      ['Meat', 'Dairy', 'Beverages', 'Produce'].sample,
+      rand(5000),
+      ['East', 'West', 'North', 'South'].sample
+    ]
+  end
+
+  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
+
+p.serialize 'pivot_table_example.xlsx'
+```
+
+## Output
+
+![Output](images/pivot_table_example.png "Output")
-- 
cgit v1.2.3