SetValue Method (Row)

Sets the value in a specified column in the current row.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetValue( _
   ByVal column As Integer, _
   ByVal value As Object _
)

'Usage
 
Dim instance As Row
Dim column As Integer
Dim value As Object
 
instance.SetValue(column, value)

public void SetValue( 
   int column,
   object value
)

Parameters

column: The column index.
value: The value for the cell.

Example

This example uses the SetValue method.

C#
VB.NET

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(Windows.UI.Colors.Gray);
gcSpreadSheet1.Sheets[0].Rows[1].Foreground = new SolidColorBrush(Windows.UI.Colors.Red);
gcSpreadSheet1.Sheets[0].Rows[1].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("0.00");
gcSpreadSheet1.Sheets[0].Rows[1].FontSize = 12;
gcSpreadSheet1.Sheets[0].Rows[1].FontWeight =  Windows.UI.Text.FontWeights.Bold;
gcSpreadSheet1.Sheets[0].Rows[1].BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Rows[1].BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Rows[1].BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Rows[1].BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.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(Windows.UI.Colors.Gray)
gcSpreadSheet1.Sheets(0).Rows(1).Foreground = New SolidColorBrush(Windows.UI.Colors.Red)
gcSpreadSheet1.Sheets(0).Rows(1).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("0.00")
gcSpreadSheet1.Sheets(0).Rows(1).FontSize = 12
gcSpreadSheet1.Sheets(0).Rows(1).FontWeight =  Windows.UI.Text.FontWeights.Bold
gcSpreadSheet1.Sheets(0).Rows(1).BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
gcSpreadSheet1.Sheets(0).Rows(1).BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
gcSpreadSheet1.Sheets(0).Rows(1).BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
gcSpreadSheet1.Sheets(0).Rows(1).BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)

Reference

Row Class
Row Members