InsertRows Method
See Also DLL Example 1 Example 2
Applies To
fpSpread control
Description
Inserts a row or rows before the specified row.
Syntax
C++
void CSpreadSheet::InsertRows(long lRow, long lNumRows);
Visual Basic
fpSpread1.InsertRows(ByVal lRow As Long, ByVal lNumRows As Long)
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| lRow | Row number of row before which to insert new row or rows (Value must be greater than 0.) |
| lNumRows | Number of rows to insert |
Remarks
Call the InsertRows method to insert rows. This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.
| Caution: Inserting rows does not increase the number of rows set by the MaxRows property. To avoid losing data, increase the value of the MaxRows property before inserting rows. |
Call the InsertCols method to insert columns.
Return Type
None
See Also
MaxRows property
DeleteRows, InsertCols method
DLL Correspondence
SSInsRow function