add frozen header example

1 files changed, 14 insertions, 0 deletions

diff --git a/examples/example.rb b/examples/example.rb
index 446dd79c..23fc30d0 100755
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -350,6 +350,20 @@ wb.add_worksheet(:name => 'comments') do |sheet|
   sheet.add_comment :ref => 'A1', :author => 'Bob', :text => 'Yes We Can!'
 end
 
+## Frozen/Split panes
+## ``` ruby
+wb.add_worksheet(:name => 'fixed headers') do |sheet|
+  sheet.add_row(['',  (0..99).map { |i| "column header #{i}" }].flatten )
+  100.times.with_index { |index| sheet << ["row header", (0..index).to_a].flatten }
+  sheet.sheet_view.pane do |pane|
+    pane.top_left_cell = "B2"
+    pane.state = :frozen_split
+    pane.y_split = 1
+    pane.x_split = 1
+    pane.active_pane = :bottom_right
+  end
+end
+
 ##Validate and Serialize
 
 #```ruby