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.

[bepelletier]

Hi there, I still have the same issue pour Excel Parser even when using the unformatted option, the snap returns 72996.84000000001 while it is 72996.84 in Excel. Should I open a ticket in Snaplogic?