From 993d1b7d05f969bdaa44cd859f71c4783c2a733b Mon Sep 17 00:00:00 2001 From: Jan-Hendrik Hühne Date: Wed, 6 Jun 2012 18:59:32 +0200 Subject: Simple example. --- examples/sheet_view.rb | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 examples/sheet_view.rb 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 -- cgit v1.2.3