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 Reading values unformatted is not currently possible in the Excel Parser Snap. We are working on adding support for this based on your request.

  • 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?