setRepeatingRows

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

setRepeatingRows( workbook, rowRange )

##Required arguments

• workbook spreadsheet object
• rowRange string: range of rows to repeat on every printed page in the form "NUMBER:NUMBER" e.g. "1:2"

##Example

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