Skip to content

Instantly share code, notes, and snippets.

@ruckus

ruckus/axlsx_freeze_pane.rb

Created August 6, 2015 04:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ruckus/80fdaa2594015f644d55 to your computer and use it in GitHub Desktop.
Save ruckus/80fdaa2594015f644d55 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment