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.

[dmiller]

Looks like a defect was submitted for this issue.

[rohithmadhavan]

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

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

[rohithmadhavan]

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