Excel Parser : reading formatted values instead of the original value

[dgupta]

Hi there,

I am using excel file to read the sheet and i am noticing that it is truncating decimals. It reads the formatted column values instead of the actual values…

for example … Value: -123.943661971831 is read as -$123.94

Whereas i want the actual value not the formatted.

[rohithmadhavan]

@dgupta The Excel Parser Snap now has a new property “Cell formatting” starting with Snap Pack version transform7780 and is available as latest in the UAT and production environments. Setting the property to “Unformatted” should solve your issue.