setRepeatingRows - cfsimplicity/spreadsheet-cfml GitHub Wiki

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"

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 first (header) row repeat on every page
spreadsheet.setRepeatingRows( workbook, "1:1" );