shiftRows

Shifts one or more rows up or down.

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.

Example

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