removeRowBreak - cfsimplicity/spreadsheet-cfml GitHub Wiki

Removes a previously set page break

removeRowBreak( workbook, row )

Required arguments

  • workbook spreadsheet object
  • row numeric: row from which to remove the page break

Chainable? Yes.

Examples

spreadsheet = New spreadsheet();
workbook = spreadsheet.newXlsx();
rowData = [ "column1", "column2", "column3", "column4" ];
spreadsheet
  .addRows( workbook, [ rowData, rowData, rowData, rowData ] );//add a 4x4 dataset
  .setRowBreak( workbook, 3 );// add a page break after row 3
  .removeRowBreak( workbook, 3 ); // undo the previous action