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...
dgupta's avatar
dgupta
New Contributor
7 years ago

Thanks Rohit. I am interested in reading the original value instead of the formatted value. Is there a way to read it?

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?