Hello,
Let's say I have an Excel file with this data:
Column A | Column B | |
Row 1 | Sara | 99.43 |
Row 2 | Joe | 12.88 |
Row 3 | Tim | NA |
Row 4 | Karl | No data |
So, I want to force the "Excel Reader (XLS)" node to read "Column B" as Double... always.
I don't want the node to consider that column as String, and then I have to do the "String to Number" conversion.
The reason I don't want to do the conversion, I because I loose the decimals in the cell. For example, let's say B2 shows 12.88 because of the cell formating, but the actual value of the cell is 12.8799999. Using "String to Number", I loose the decimals.
I attach another example.
Any ideas?
Thanks!