summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
-rwxr-xr-xexamples/example.rb14
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