GetValue Method (DefaultSheetDataModel)

Gets the value of the cell for the specified row and column.

Syntax

Visual Basic
C#

'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.

Visual Basic

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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
SetValue Method