addPageBreaks - cfsimplicity/spreadsheet-cfml GitHub Wiki

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" );