Excel with Ruby: Printing Header Row for every page with axlsx

repeating_header.rb

#```ruby
require 'axlsx'
p = Axlsx::Package.new
wb = p.workbook

wb.add_worksheet(:name => "repeated header") do |sheet|
  sheet.add_row %w(These Column Header Will Render On Every Printed Sheet)
  200.times { sheet.add_row %w(1 2 3 4 5 6 7 8) }
  # This is the magic
  wb.add_defined_name("'repeated header'!$1:$1", :local_sheet_id => sheet.index, :name => '_xlnm.Print_Titles') 
end

p.serialize 'repeating_headers.xlsx'