Spread 8.0 Documentation
InsertRows Method
Support Options
ActiveX Reference > ActiveX Methods > InsertRows Method

Glossary Item Box

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.