Function TsWorksheet.ReadNumericValue
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Relativity · 2018-02-28 07:54

What does the function TsWorksheet.ReadNumericValue do ?
What is the meaning of the returned Boolean value ?

I have to read Excel sheet cells and tell apart empty cells from cells
containing zero: should I first read the cell content as a string, to
check if it is empty ?

Thanks in advance.

----------------------------------------------------------------------
wp · 2018-02-28 08:15

This is from the function comments (it should be in the chm file,
too):
Quote  Returns the numeric equivalent of the cell contents. This is
the NumberValue
  of a number cell, the DateTimeValue of a date/time cell, the ordinal
BoolValue
  of a boolean cell, or the string converted to a number of a string
cell.
  All other cases return NaN.

  @param   ACell   Cell to be considered
  @param   AValue  (output) extracted numeric value
  @return  True if conversion to number is successful, otherwise
false   
But I think this is overkill for you task. Just check the field
NumberValue of the cell for zero:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i function
IsZero(ACell: PCell): Boolean;begin  Result := (ACell <> nil) and
(ACell^.ContentType = cctNumber) and (ACell^.NumberValue = 0);end;
To get the cell at a given row/column call
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i var  cell:
PCell;...  cell := Worksheet.FindCell(ARow, ACol);