Spread Silverlight Documentation
Rows Property (Worksheet)
Example 


Gets the one-dimensional collection of Row objects.
Syntax
'Declaration
 
Public ReadOnly Property Rows As Rows
'Usage
 
Dim instance As Worksheet
Dim value As Rows
 
value = instance.Rows
public Rows Rows {get;}

Property Value

The one-dimensional collection of Row objects.
Example
This example uses the Rows property.
for (int i = 0; i < gcSpreadSheet1.Sheets[0].ColumnCount; i++)
            {
                gcSpreadSheet1.Sheets[0].Rows[1].SetValue(i, i);
            }
gcSpreadSheet1.Sheets[0].Rows[1].Background = new SolidColorBrush(Colors.Gray);
gcSpreadSheet1.Sheets[0].Rows[1].Foreground = new SolidColorBrush(Colors.Red);
gcSpreadSheet1.Sheets[0].Rows[1].Formatter = new GeneralFormatter("0.00");
gcSpreadSheet1.Sheets[0].Rows[1].FontSize = 12;
gcSpreadSheet1.Sheets[0].Rows[1].FontWeight = FontWeights.Bold;
gcSpreadSheet1.Sheets[0].Rows[1].BorderBottom = new BorderLine(Colors.Green, BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Rows[1].BorderTop = new BorderLine(Colors.Green, BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Rows[1].BorderLeft = new BorderLine(Colors.Green, BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Rows[1].BorderRight = new BorderLine(Colors.Green, BorderLineStyle.Thin);
For i As Integer = 0 To gcSpreadSheet1.Sheets(0).ColumnCount - 1
    gcSpreadSheet1.Sheets(0).Rows(1).SetValue(i, i)
Next
gcSpreadSheet1.Sheets(0).Rows(1).Background = New SolidColorBrush(Colors.Gray)
gcSpreadSheet1.Sheets(0).Rows(1).Foreground = New SolidColorBrush(Colors.Red)
gcSpreadSheet1.Sheets(0).Rows(1).Formatter = New GeneralFormatter("0.00")
gcSpreadSheet1.Sheets(0).Rows(1).FontSize = 12
gcSpreadSheet1.Sheets(0).Rows(1).FontWeight = FontWeights.Bold
gcSpreadSheet1.Sheets(0).Rows(1).BorderBottom = New BorderLine(Colors.Green, BorderLineStyle.Thin)
gcSpreadSheet1.Sheets(0).Rows(1).BorderTop = New BorderLine(Colors.Green, BorderLineStyle.Thin)
gcSpreadSheet1.Sheets(0).Rows(1).BorderLeft = New BorderLine(Colors.Green, BorderLineStyle.Thin)
gcSpreadSheet1.Sheets(0).Rows(1).BorderRight = New BorderLine(Colors.Green, BorderLineStyle.Thin)
Requirements

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

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.