diff options
| -rw-r--r-- | examples/sheet_view.rb | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/examples/sheet_view.rb b/examples/sheet_view.rb new file mode 100644 index 00000000..2cbe680a --- /dev/null +++ b/examples/sheet_view.rb @@ -0,0 +1,34 @@ +#!/usr/bin/env ruby -w -s +# -*- coding: utf-8 -*- +$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib" +require 'axlsx' + +p = Axlsx::Package.new +ws = p.workbook.add_worksheet :name => "Sheetview - Split" +ws.sheet_view do |vs| + vs.pane do |p| + p.active_pane = :top_right + p.state = :split + p.x_split = 11080 + p.y_split = 5000 + p.top_left_cell = 'C44' + end + + vs.add_selection(:top_left, { :active_cell => 'A2', :sqref => 'A2' }) + vs.add_selection(:top_right, { :active_cell => 'I10', :sqref => 'I10' }) + vs.add_selection(:bottom_left, { :active_cell => 'E55', :sqref => 'E55' }) + vs.add_selection(:bottom_right, { :active_cell => 'I57', :sqref => 'I57' }) +end + + +ws = p.workbook.add_worksheet :name => "Sheetview - Frozen" +ws.sheet_view do |vs| + vs.pane do |p| + p.state = :frozen + p.x_split = 3 + p.y_split = 4 + end +end + + +p.serialize 'sheet_view.xlsx'
\ No newline at end of file |