diff options
| -rwxr-xr-x | examples/example.rb | 14 |
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 |
