ungroupRows - cfsimplicity/spreadsheet-cfml GitHub Wiki

Ungroups previously grouped rows

ungroupRows( workbook, startRow, endRow )

Required arguments

• workbook spreadsheet object
• startRow numeric: the row at which the group begins (inclusive)
• endRow numeric: the row at which the group ends (inclusive)

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
  .groupRows( workbook, 2, 3 );
  .ungroupRows( workbook, 2, 3 );