SpreadsheetShiftRows

Shifts one or multiple rows up or down in a spreadsheet object.

Method Signature

SpreadsheetShiftRows(spreadsheetObj=[any], start=[any], end=[any], rows=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
start	NUMERIC	true	The starting row number (1-based).
end	NUMERIC	false	The ending row number (1-based). Optional; defaults to start if not provided.
rows	NUMERIC	false	The number of rows to shift (positive for down, negative for up). Optional; defaults to 1 if not provided.

Examples

Shift rows up or down:

// Shift rows starting at position 5, 3 rows down
var spreadsheet = SpreadsheetNew();
SpreadsheetShiftRows( spreadsheet, 5, 3 );

Related

• SpreadsheetShiftColumns() - Shift columns

• SpreadsheetAddRow() - Add row

• SpreadsheetDeleteRow() - Delete row