repeat headings

29 views
Skip to first unread message

lvankon...@gmail.com

unread,
Jun 22, 2016, 9:35:11 AM6/22/16
to axlsx
Hi, I try to repeat headings in all pages but I don't know what is wrong.

I am using

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) }
wb.add_defined_name("'repeated header'!$1:$1", :local_sheet_id => sheet.index, :name => '_xlnm.Print_Titles')
end

But not repeat, can you help me?

Thanks in advanced.
Lourdes

Reply all
Reply to author
Forward
0 new messages