Adds a row or rows to the data model for a sheet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overridable Sub AddRows( _
ByVal row As Integer, _
ByVal count As Integer _
) |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim row As Integer
Dim count As Integer
instance.AddRows(row, count) |
Parameters
- row
- Row index where the new rows are to be added
- count
- Number of rows to be added
Example
This example adds two rows to the active sheet.
| C# | Copy Code |
|---|
DialogResult dlg;
fpSpread1.ActiveSheet.Rows.Count = 4;
dlg = MessageBox.Show("Do you want to add some rows?", "AddRows", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
fpSpread1.ActiveSheet.AddRows(0, 2);
} |
| Visual Basic | Copy Code |
|---|
Dim dlg As DialogResult
FpSpread1.ActiveSheet.Rows.Count = 4
dlg = MessageBox.Show("Do you want to add some rows?", "AddRows", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
FpSpread1.ActiveSheet.AddRows(0, 2)
End If |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
