cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Parser : reading formatted values instead of the original value

dgupta
New Contributor

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.

5 REPLIES 5

dmiller
Admin Admin
Admin

Looks like a defect was submitted for this issue.


Diane Miller
Community Manager

rohithmadhavan
Employee
Employee

@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
New Contributor

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

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