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

Question

Hi everyone, 
 I&rsquo;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?

jesush905075 · Accepted Answer

check the latest version of this plugin: Appian Community

Stefan Helzle · Answer

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

Shubham Aware · Answer

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

Stefan Helzle · Answer

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.

Harsha Sharma · Answer

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.

Shubham Aware · Answer

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

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

Top Replies