Forum Discussion

dgupta's avatar
dgupta
New Contributor
7 years ago

Excel Parser : reading formatted values instead of the original value

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.94...
rohithmadhavan's avatar
rohithmadhavan
Employee
7 years ago

@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's avatar
bepelletier
New Contributor II
12 months ago

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?