setRepeatingColumns

Specifies columns that should appear on every page when the current sheet is printed.

setRepeatingColumns( workbook, columnRange )

Required arguments

• workbook spreadsheet object
• columnRange string: range of columns to repeat on every printed page in the form "LETTER:LETTER", e.g. "A:B"

Chainable? Yes.

Example

data = QueryNew( "ID,First,Last", "VarChar,VarChar", [ [ 1,"Susi","Sorglos" ], [ 2,"Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
// Make the ID column repeat on every page
spreadsheet.setRepeatingColumns( workbook, "A:A" );