Excel Parser : reading formatted values instead of the original value

Question

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.

dmiller · Answer

Looks like a defect was submitted for this issue.

rohithmadhavan · Answer

@dgupta The Excel Parser Snap respects the cell formats present in the input file. The Parser output will look similar to the sheet when opened in Excel, and the Snap performs no additional truncation.
It seems like the cell referenced is formatted with the Currency type. If you’d like to retain the type, the decimal width needs to be increased to accommodate the additional decimal places. The default decimal width for the Currency type is 2.
The alternative is to set the cell to use the Number type with decimal width set to Auto. This is probably what you’re looking for since the expected output lacks a $ sign.

dgupta · Answer

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

rohithmadhavan · Answer

@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 · Answer

@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.

Forum Discussion

Excel Parser : reading formatted values instead of the original value

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?