Gets the number of rows in the displayed page on the client.

Syntax

[JavaScript]

var ret = FpSpread1.GetRowCount();

Parameters

None

Return Type

Integer, number of rows

Remarks

This method returns a count of the rows in the displayed spreadsheet on the client. For a count of the columns, refer to GetColCount.

Example

This is a sample that uses the method to count the rows in order to get a value from each row. On the client side, the script that contains the method would look like this:

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

Copyright © GrapeCity, inc. All rights reserved.