Re: What is the recommended way to handle character cells that have numeric values?

On 11/12/2015 2:59 PM, Darryl Freinkel wrote:

I have the situation the a column has values that are sometimes numeric and
sometimes character. Example: 22.

The value brought in is 22.00.

Is this a case where I need to override the system value and if I know it's
character use the string value?

Fortunately, the cell itself knows if it is holding a character or a
number. I think this example came from Scott:

// based on the cell type as reported by POI, extract the value
// these WHERE clauses extract to
// generic fields named tempFloat and tempChar
// which will be assigned to the appropriate DB2 fields
type = SSCell_getCellType(cell);
tempChar = '';
tempFloat = 0.0;

// what is the cell type?
select;
when type = CELL_TYPE_STRING;
tempChar = String_getBytes(SSCell_getStringCellValue(cell));

when type = CELL_TYPE_FORMULA;
// evaluate the formula
newCellValue = evaluate(formulaEvaluator: cell);
newType = CellValue_getCellType(newCellValue);
if newType = CELL_TYPE_NUMERIC;
tempFloat = CellValue_getNumberValue(newCellValue);
else;
// handle Formula error
endif;

when type = CELL_TYPE_NUMERIC;
tempFloat = SSCell_getNumericCellValue(cell);

when type = CELL_TYPE_BOOLEAN;
tempBoolean = SSCell_getBooleanCellValue(cell);

other;
// handle as-yet unknown cell type

endsl;