addPageBreaks

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 3 revisions

Adds page breaks when printed to the currently active sheet at the specified row and/or column numbers.

addPageBreaks( workbook, rowBreaks, columnBreaks )

Required arguments

workbook spreadsheet object
rowBreaks string: A comma delimited list of the rows where page breaks should be added AND/OR
columnBreaks string: A comma delimited list of the columns where page breaks should be added

Chainable? Yes.

Example

data = QueryNew( "First,Last,Initials","VarChar,VarChar,VarChar",[ [ "Susi","Sorglos","SS" ],[ "Frumpo","McNugget","FM" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.addPageBreaks( workbook, "1,2", "3" );