GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > SetValue Method : SetValue(Int32,Int32,Object) Method |
'Declaration Public Overloads Sub SetValue( _ ByVal row As System.Integer, _ ByVal column As System.Integer, _ ByVal value As System.Object _ )
'Usage Dim instance As Worksheet Dim row As System.Integer Dim column As System.Integer Dim value As System.Object instance.SetValue(row, column, value)
for (int rowIndex = 0; rowIndex < this.gcSpreadSheet1.ActiveSheet.RowCount; rowIndex++) { for (int colIndex = 0; colIndex < this.gcSpreadSheet1.ActiveSheet.ColumnCount; colIndex++) { this.gcSpreadSheet1.Sheets[0].SetValue(rowIndex, colIndex, rowIndex * 10 + colIndex); } }
For rowIndex As Integer = 0 To Me.gcSpreadSheet1.ActiveSheet.RowCount - 1 For colIndex As Integer = 0 To Me.GcSpreadSheet1.ActiveSheet.ColumnCount - 1 Me.GcSpreadSheet1.Sheets(0).SetValue(rowIndex, colIndex, rowIndex * 10 + colIndex) Next Next
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