blob: b5ffcc05575c374af4e9234a229ecf8ad5334e48 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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'
|
