example.rb in axlsx-1.1.7

- old
+ new

@@ -1,8 +1,8 @@
 #!/usr/bin/env ruby -w -s
 # -*- coding: utf-8 -*-
-# $LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
+$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
 
 #```ruby
 require 'axlsx'
 
 p = Axlsx::Package.new
@@ -274,10 +274,12 @@
   sheet.add_chart(Axlsx::Line3DChart, :title => "example 6: Line Chart", :rotX => 30, :rotY => 20) do |chart|
     chart.start_at 0, 2
     chart.end_at 10, 15
     chart.add_series :data => sheet["B1:E1"], :title => sheet["A1"]
     chart.add_series :data => sheet["B2:E2"], :title => sheet["A2"]
+    chart.catAxis.title = 'Y Axis'
+    chart.valAxis.title = 'X Axis'
   end
 end
 #```
 
 ##Generating A Scatter Chart
@@ -346,9 +348,23 @@
 ## Add Comments to your spreadsheet 
 #``` ruby
 wb.add_worksheet(:name => 'comments') do |sheet|
   sheet.add_row ['Can we build it?']
   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