Spread for ASP.NET 9.0 Product Documentation
GetValue Method (DefaultSheetDataModel)
Example 


Row index of the cell in the model
Column index of the cell in the model
Gets the value of the cell for the specified row and column.
Syntax
'Declaration
 
Public Overrides Function GetValue( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As Object
'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim column As Integer
Dim value As Object
 
value = instance.GetValue(row, column)
public override object GetValue( 
   int row,
   int column
)

Parameters

row
Row index of the cell in the model
column
Column index of the cell in the model

Return Value

Object containing the value in the cell
Remarks
Use the SetValue method to add data to a cell.
Example
This example calls the SetValue method sets a value for cell A1 and calls GetValue method to return the value to a list box.
Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel=CType(FpSpread1.ActiveSheetView.DataModel,FarPoint.Web.Spread.Model.DefaultSheetDataModel)
dm.SetValue(0,0,"A1")
ListBox1.Items.Add(dm.GetValue(0,0))
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm=(FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dm.SetValue(0,0,"A1");
ListBox1.Items.Add(dm.GetValue(0,0).ToString());
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
SetValue Method

 

 


Copyright © GrapeCity, inc. All rights reserved.