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?

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.