InsertRows method: PSSpreadsheet class

Syntax

InsertRows(startrow, rowcount)

Description

Use the InsertRows method to insert one or more rows into the active spreadsheet.

Parameters

Parameter Description

startrow

Specifies the starting row number.

rowcount

Specifies the number of rows to be inserted.

Returns

(Optional) A Boolean value: True if the method completes successfully, False otherwise.

Example

The following example inserts three rows into the spreadsheet.

&startrow = 2;
&rowcount = 3;
&ssObject.InsertRows(&startrow, &rowcount);