AddRows(Int32,Int32) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub AddRows( _
   ByVal row As System.Integer, _
   ByVal count As System.Integer _
)

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim count As System.Integer
 
instance.AddRows(row, count)

public void AddRows( 
   System.int row,
   System.int count
)

Parameters

row: The row index at which to add rows.
count: The number of rows to add.

This example uses the AddRows method.

C#

gcSpreadSheet1.Sheets[0].SetValue(0, 0, "value");
gcSpreadSheet1.Sheets[0].AddRows(0, 2);
gcSpreadSheet1.Sheets[0].AddColumns(0, 2);
gcSpreadSheet1.Sheets[0].SetRowHeight(0, SheetArea.Cells, 50d);
gcSpreadSheet1.Sheets[0].SetColumnWidth(0, SheetArea.Cells, 150d);
gcSpreadSheet1.Sheets[0].Rows[0].Background = new SolidColorBrush(Colors.Gray);
gcSpreadSheet1.Sheets[0].Columns[0].Background = new SolidColorBrush(Colors.Brown);

VB.NET

GcSpreadSheet1.Sheets(0).SetValue(0, 0, "value")
GcSpreadSheet1.Sheets(0).AddRows(0, 2)
GcSpreadSheet1.Sheets(0).AddColumns(0, 2)
GcSpreadSheet1.Sheets(0).SetRowHeight(0, SheetArea.Cells, 50.0)
GcSpreadSheet1.Sheets(0).SetColumnWidth(0, SheetArea.Cells, 150.0)
GcSpreadSheet1.Sheets(0).Rows(0).Background = New SolidColorBrush(Colors.Gray)
GcSpreadSheet1.Sheets(0).Columns(0).Background = New SolidColorBrush(Colors.Brown)

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List