shiftRows - cfsimplicity/spreadsheet-cfml GitHub Wiki

Shifts one or more rows up or down. The contents of the shifted row or rows, including empty cells, overwrites data in the row or rows to which it is shifted.

shiftRows( workbook, start [, end [, offset ] ] )

Required arguments

  • workbook spreadsheet object
  • start numeric: The number of the first, or only, row to shift.

Optional arguments

  • end numeric: The number of the last row to shift. If omitted the function shifts a single row.
  • offset numeric default=1: The positive (down) or negative (up) number of rows to shift by. If omitted the function shifts the row down by one.

Chainable? Yes.

Example

data = QueryNew( "First,Last", "VarChar,VarChar", [ [ "Susi","Sorglos" ], [ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.shiftRows( workbook, 1, 1, 1 );