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

Glossary Item Box

DeleteRows Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Deletes the specified row or rows.

Syntax

C++

void CSpreadSheet::DeleteRows (long lRow, long lNumRows);

Visual Basic

fpSpread1.DeleteRows(ByVal lRow As Long, ByVal lNumRows As Long)

Parameters

The following parameters are available:

Parameter Description
lRow Row number of first row to delete
lNumRows Number of rows to delete

Remarks

Deleting rows does not decrease the number of rows set by the MaxRows property. When you call the DeleteRows method to delete a row, a blank row is automatically added at the end of the sheet.

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.

Return Type

None

See Also

MaxRows, Sheet properties

DeleteCols method

DLL Correspondence

SSDelRow function

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