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

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

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

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.

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

Saikrishnan V said:

plugin is returning the formatted display value

How do you know?

We using the plugin in the expression rule and below is the extracted data (highlighted one is the display value).

This is showing a text type. So somewhere the numeric value is turned into text. The root cause could be the Excel, or the plugin.

But if you cannot modify the Excel, nor the plugin, not many options are left.

You could try to just dump the Excel into a database table and check whether the data types survive this transformation.

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.

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

check the latest version of this plugin: Appian Community