Skip to content

setRepeatingColumns

Julian Halliwell edited this page Dec 3, 2015 · 4 revisions

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"

##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" );
Clone this wiki locally