diff options
| author | Randy Morgan <[email protected]> | 2013-09-30 09:53:29 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2013-09-30 09:53:29 +0900 |
| commit | 3a174bc69ac213939565da20e14eeb9e18d5413f (patch) | |
| tree | d61f6df7c40e498dd052ead6af9e992d11ce2ac1 /examples | |
| parent | 09c9170e50ed4550015e34fdb54b7433bee0ef40 (diff) | |
| download | caxlsx-3a174bc69ac213939565da20e14eeb9e18d5413f.tar.gz caxlsx-3a174bc69ac213939565da20e14eeb9e18d5413f.zip | |
add name attribute to cell to create defined names for a single cell. https://github.com/randym/axlsx/issues/241
Diffstat (limited to 'examples')
| -rw-r--r-- | examples/split.rb | 16 |
1 files changed, 16 insertions, 0 deletions
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' |