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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
SetValue Method