Spread for ASP.NET 7.0 Product Documentation
GetValue Method
See Also Example Support Options

FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : GetValue Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

row: Row index of the cell in the model

column: Column index of the cell in the model

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

Syntax

Visual Basic (Declaration)
Public Overrides Function GetValue( _ ByVal row As Integer, _ ByVal column As Integer _ ) As Object

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim value As Object value = instance.GetValue(row, column)

C#
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	Copy Code
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))

Visual Basic

Copy Code

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))

C#	Copy Code
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());

Copy Code

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