Spread for ASP.NET 11 Product Documentation
Getting the Value of a Cell
Spread for ASP.NET 11 Product Documentation > Client-Side Scripting Reference > Scripting Overview > Some Simple Uses of Client Scripting > Getting the Value of a Cell

You can use client-side scripting in Spread to get the value of the active cell. The following code gets the cell value of the active cell on the client side.

JavaScript
Copy Code
<script language="javascript">
  function getactval() {
  var ret FpSpread1.GetValue(FpSpread1.ActiveRow, FpSpread1.ActiveCol);
  }
</script>

For details, refer to GetValue.

You can use client-side scripting in Spread to get the value of a hidden cell. The following code gets the cell value of a hidden cell on the client side.

JavaScript
Copy Code
<script language="javascript">
  function gethidval() {
  var ret = FpSpread1.GetHiddenValue(row,columnName);
  }
</script>

In this code, the row parameter is the index of the row (number) and the columnName parameter is the name of the column (string). Remember, the string for the column name is case sensitive. For details, refer to GetHiddenValue.