tFileInputExcel reads formatted value instead numeric value in cell
I have a job which loops through an Excel spreadsheet reading one column at a time. The schema of the spreadsheet defines all columns as string, with the "Read real values for numbers" option checked.
One column contains floating point values formatted to display no decimal places. The data is read by a tJavaRow component, however I get only the displayed value passed to the tJavaRow from the tFileInputExcel.
If I change the display format in the spreadsheet so that at least one decimal place is displayed, I get the correct value, usually with more than one decimal place in the data.
Is there any way to get the tFileInputExcel to pass the underlying value in the cell rather than the displayed value?
thanks
Mario
