From 3a174bc69ac213939565da20e14eeb9e18d5413f Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Mon, 30 Sep 2013 09:53:29 +0900 Subject: add name attribute to cell to create defined names for a single cell. https://github.com/randym/axlsx/issues/241 --- examples/split.rb | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 examples/split.rb (limited to 'examples') diff --git a/examples/split.rb b/examples/split.rb new file mode 100644 index 00000000..b5ffcc05 --- /dev/null +++ b/examples/split.rb @@ -0,0 +1,16 @@ +#!/usr/bin/env ruby -w -s +# -*- coding: utf-8 -*- +$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib" +require 'axlsx' +p = Axlsx::Package.new +wb = p.workbook +wb.add_worksheet name: 'pane' do |sheet| + sheet.sheet_view.pane do |pane| + pane.top_left_cell = "B2" + pane.state = :frozen_split + pane.y_split = 2 + pane.x_split = 1 + pane.active_pane = :bottom_right + end +end +p.serialize 'pane.xlsx' -- cgit v1.2.3