# GetValue

Use the GetValue method to get the value of a cell in the specified row and column. Learn its syntax and parameters in documentation.

## Content

Gets the value of a cell in the specified row and column.

## Syntax

[JavaScript]

```javascript
var ret = FpSpread1.GetValue(row,column);
```

## Parameters

***row***
Integer, row index
***column***
Integer, column index

## Return Type

String, the value of the cell

## Remarks

This method returns the value as it is currently displayed in the cell. The row and column indexes must be valid.

## Example

This is a sample that contains the method. On the client side, the script that contains the method would look like this:

```javascript
<script type="text/javascript">
   function doCalc() {
     var rc = FpSpread1.GetRowCount();
     var total = 0;
     for (var i=0; i<rc-1; i++) {
       var value = parseFloat(FpSpread1.GetValue( i, 0 ));
       total += value;
     }
     if (!isNaN(total))
       FpSpread1.SetValue(n-1, 0, total, true);
   }
</script>
```

## See Also

[SetValue](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-SetValue)
[GetHiddenValue](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-GetHiddenValue)
[Scripting Members](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members)