axlsx_freeze_pane.rb

sheet.sheet_view do |sv|
  sv.pane do |pane|
    pane.top_left_cell = 'B1'
    pane.state = :frozen
    pane.x_split = 1
    pane.active_pane = :top_right
  end
end