Solved

Can we able to read actual value instead of display value from excel.

Forum|Forum|5 months ago
February 27, 2026
11 replies
0 views

Hi everyone,

I’m using to readexcelsheetpaging plugin to read the Excel sheet, one column having decimal values, the displayed value is rounded (around 2 decimal places), which differs from the actual raw value stored in the cell.

What I see:

Excel cell shows: 9.79
Underlying value in the cell: 9.7881336
readexcelsheetpaging returns: 9.79 (display)

Is there a way to read the actual value of a cell?

excel tool

Best answer by jesush905075

check the latest version of this plugin: Appian Community

stefanhelzle0001

Use the text() function to format the value as required.

S

saikrishnv145481Author

Hi Stefan, the plugin is returning the formatted display value (9.79) in text. I need to get the actual value (9.7881336)

Below is the excel image.

stefanhelzle0001

plugin is returning the formatted display value

How do you know?

shubhama926776

Format Excel column as Text to store/read full precision as string, then todecimal().

S

saikrishnv145481Author

Hi Shubham, we receiving the excel files from outside and we performing the extraction, so we couldn't able to format the column.

Are there any other method to retrieve the actual value or is this the only way.

shubhama926776

Raw value unreadable via plugin; uses display format.
Need to use RPA for Raw value extraction from excel.

harshas2775

The Appian smart services will extract the cell value and not the pre-formatted underlying value from excel. So you need to work with Excel here so that exact value is stored in the cell instead of the rounded value. Otherwise there is no way to retrieve the original value in Appian.

J

jesush905075Answer

check the latest version of this plugin: Appian Community

S

saikrishnv145481Author

Hi [mention:3b7f4beae3cf48459896cc23258f05e1:e9ed411860ed4f2ba0265705b8793d05] , will check this, thanks!

Sign up

Login with SSO

Login to the community

Login with SSO